REPT

The REPT function repeats a text string a specified number of times. This function is commonly used to generate repeated text patterns and formatted outputs.

Syntax

REPT(value, count)

Arguments

• value: The text string to repeat.
• count: The number of times to repeat the text string.

Return value

Returns a text string repeated the specified number of times.

Example

REPT("Qtr-", 3)

Returns Qtr-Qtr-Qtr-.

Excel equivalent

REPT