REPT Function

Spread the love

The REPT function Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.


REPT(text, number_times)
The REPT function syntax has the following arguments:
  • Text Required. The text you want to repeat.
  • Number_times Required. A positive number specifying the number of times to repeat text.
Data Formula Result
* =REPT(A2, 10) **********
Kazam =A3 & REPT(“*”, 10) Kazam**********
12000 =A4 & “/-” & REPT(“*”, 5) 12000/-*****