What is the Excel REPT Function?
The excel REPT function repeats a text with a specified number of replications.
REPT Syntax
REPT(text, number_times)
text, required, the text to repeat.
number_times, required, a positive number to determine the number of times to repeat the text.
Usage Notes:
- REPT function returns empty text “” if number_times argument is zero.
- REPT function truncates any decimal number in number_times argument, use only the integer number.
- REPT function returns a #VALUE error if the repeated text longer than 32,767 characters.
How to Use REPT Function in Excel
Below is an example of REPT function usage and the results.
REPT Function #1
=REPT(A2,B2)
REPT function returns nothing If a number_times argument is zero or empty.
REPT Function #2
=REPT(A3,B3)
The result is an excel word, repeated twice without spaces.
REPT Function #3
=REPT(A4,B4)
The number_times argument must be a positive integer number. If you use a negative number, the result is a #VALUE! error.
REPT Function #4
=REPT(A5,B5)
If you use a positive decimal number, Excel truncates it and take the integer number. No round process, Excel truncates the decimal number and use the integer number.
The result is the word “go” is repeated three times, not four times.
REPT Function #5
=REPT(A6,B6)
The result is a #VALUE error.
No more than 31,767 characters for REPT function result. The word “Microsoft” which was repeated 3,641 times resulted in 32,769 characters length.