To use this function, choose .
 
Repeats text a specified number of times. 
 
 
Syntax
 
REPT(text,number_times)
 
For text, specify the text or the column of text. For number_times, specify how many times to repeat the text.
  
Example
 
 
 
| Column | Calculator expression | Result | 
 
| C1 contains "A" | REPT(C1,4) | AAAA |