REPT Function in Excel repeats the string for a specified number of times
Syntax of REPT Function in Excel (Repeat Function):
REPT( text, number_times )
Where,
- text –Text String to be repeated
- number_times – number of times the text string to be repeated.
Example of REPT Function in Excel (Repeat Function):
Formula
- Excel REPT Function, takes the text string and the number of repetition as arguments
- In Row number 5 the number of repetition is 0 so REPT Function returns the empty string.
- From Row number 2 to 4 the REPT Function repeats the strings to the specified number of times.