It repeats a specific text a given number of times.
The syntax of the function is the following:
REPT(text, number_times)
text: The text you want to repeat.
number_times: The number of times you want to repeat the text.
If number_times is 0 it returns an empty string (“”)
Its result cannot be longer than 32,767 characters. If it is longer it will return a #VALUE! error.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the REPT function:
In the cell range C2:C7 repeat the character * as many times as the rating of the corresponding movie indicates.