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 |