Home Privacy Policy Feedback Link to us Site Map Forums

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:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

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"