Repeats text a number of times.
Sample Usage
REPT(-,10)
REPT(C5,3)
Syntax
REPT(text, [number])
- text - The text to be repeated.
- number - [OPTIONAL] The number of repetitions.
Examples
REPT(-,10) repeats a '-' ten times.
REPT(C5,3) repeats the contents of cell C5 three times.
Notes
- If number is 0 (zero), REPT returns "" (empty text).
- If number is not an integer, it is truncated.
- REPT does not insert spaces between repetitions of text . If spaces are desired, a space must be appended to the end of the value of text .