How to Use REPT Function

The REPT function repeats a text string with a specified number of times.


=REPT(text, number_times)


– Text is required, the text string that you need to repeat;

– Number_times is required, the times that the text string will be repeated.


– Number_times needs to be greater than or equal to 0 and cannot be omitted;

– If number_times is with decimals, only integer portion will be extracted;

– If number_times is negative, the result returns #VALUE!;

– The result cannot be longer than 32,767 characters, or REPT returns #VALUE!

Example: Display "ABC" 3 times in cell B1.

= REPT("ABC",3)

The result returns "ABCABCABC", repeated 3 times.

Download: REPT Function

Leave a Reply