Repeats text a given number of times. Use REPT to add a number of instances of a text string.



Text     is the text you want to repeat.

Number_times     is a positive number specifying the number of times to repeat text.


  • 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!.



Description (Result)

=REPT("*-", 3)

Displays the string 3 times (*-*-*-)


Displays a dash 10 times (----------)

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!