Description
Repeats a text value a specified number of times.
NOTES
- The function repeats the exact text, including spaces.
- If number_times is negative or zero, the function returns an error.
- If the resulting text exceeds Excel’s maximum text length, the function returns an error.
Syntax
Copied!=REPT(text, number_times)
SAMPLE-1
EXAMPLE 1.1
Copied!=REPT(A2:A6, 5)