Kornilios Ampatzis/ April 22, 2019/ Functions

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:

Practice

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.

Share this Post