Repeats text a given number of times. Use REPT to add a number of instances of a text string.
Syntax
REPT(text,number_times)
Text is the text you want to repeat.
Number_times is a positive number specifying the number of times to repeat text.
Remarks
-
If number_times is 0 (zero), REPT returns "" (empty text).
-
If number_times is not an integer, it is truncated.
- The result of the REPT function cannot be longer than 2000 characters, or REPT returns #VALUE!.
Examples
| Formula |
Description (Result) |
| =REPT("*-", 3) |
Displays the string 3 times (*-*-*-) |
| =REPT("-",10) |
Displays a dash 10 times (----------) |