The Excel Rept function returns a supplied text string, repeated a specified number of times.
The format of the function is:
Where the arguments are as follows:
|text||-||The string to be repeated|
The resulting text string must be no longer than 32,767 characters. If it is longer than this, the Rept function returns the Excel #VALUE! error.
The following spreadsheet shows three examples of the Excel Rept function.
Note that in the above spreadsheets:
Further examples of the Excel Rept function are provided on the Microsoft Office website.
If you get an error from the Excel Rept Function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if the result of the Rept function is more than 32,767 characters long.|