REPT Function Explained
The REPT Function in Microsoft Excel repeats a given text string a specified number of times. It takes two arguments: the text string to be repeated and the number of times to repeat it. It returns a text string that is the result of repeating the given text string the specified number of times.
REPT Function Syntax
REPT(text, number_times)
- text: The text or characters you want to repeat.
- number_times: The number of times to repeat text.