| Syntax |
| =REPT(text,number_times) |
| Purpose / Description |
| Returns a text string that is a repetition of a given text string a number of times. |
| Arguments |
| Name |
Type |
Description |
| text |
text string |
A constant, reference or nested expression that returns the base text (which may consist of only one character if appropriate) which will be repeated to create the result. |
| number_times |
number |
A constant, reference or nested expression that returns the number of times that the base text string is to be repeated to generate the result. |
| Return Values |
| Type |
Specific Value |
Description |
| text string |
|
A text string consisting of number_times repetitions of text. |
| error |
#VALUE! |
If the value passed to number_times < 0 |
| error |
#VALUE! |
If the length of the text string to be produced, being the product of the number_times argument and the character count of the text string text > 32,767. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Examples: |
Open / download sample workbook: REPT.xlsx |
| |