Excel REPT Function

Using the Excel REPT Function

Excel REPT Function

Summary

The Excel REPT function will repeat text a given number of times. For example, =REPT("*", 3) would produce ***.

Syntax

=REPT (text, number_times)

Syntax Breakdown

Text
Required. The text you want to repeat.

Number Times
Required. The number of times you want to repeat text. This argument must be a positive integer. Non-integer numbers will be truncated.

The function returns "" (empty text) if number times is 0 (zero).

Usage Notes

The REPT function will repeat text a given number of times. The function is useful if you need to fill a cell or pad values to a specified length.

#VALUE! Error
The function will return the #VALUE! error if the output is longer than 32,767 characters.