REPT

  • Updated

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 .