A to Z of Excel Functions: The REPT Function

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the REPT function.

The REPT function

The REPT function repeats text a given number of times.  The REPT function repeats text a given number of times.  The REPT function repeats text a given number of times.  The REPT function repeats text a given number of times.  The REPT function repeats text a given number of times.  The REPT function repeats ...

You may use the REPT function to fill a cell with a number of instances of a text string.

It has the following syntax:

The REPT function has the following arguments:

• text: this is required and represents the text you wish to repeat
• number_times: also required, this is a positive number specifying the number of times to repeat said text.

It should be noted that:

• if number_times is zero [0], REPT returns "" (empty text)
• if number_times is not an integer, it is truncated
• the result of the REPT function cannot be longer than 32,767 characters, else REPT returns #VALUE!

Please see my examples below (including some more obscure uses rather than the usual bar chart images): 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here.