Excel: Rept Function

In Excel, the Rept function returns a repeated text value a specified number of times.

The syntax for the Rept function is:

Rept( text, number )

text is the text value to repeat.

number is the number of times to repeat the text value.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Rept(A1, 3) would return "abcdabcdabcd"

=Rept(A2, 2) would return "isis"

=Rept("apples", 2) would return "applesapples"