REPT Formula in Excel

 

What Does It Do ?

This function repeats a piece of text a specified number of times.

You need to specify the text to be repeated and how many times to repeat it.

Syntax

=REPT(TextToRepeat,Repetitions)

The maximum number of repetitions is 200.

Formatting

No special formatting is needed.

Example 1

The following table was used to display a simple histogram of sales figures.

The =REPT() function uses the value of Sales, but this is divided by 100 to scale down the number of repetitions to below the maximum of 200.