# A to Z of Excel Functions: The REPT Function

4 November 2024

*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:

**REPT(text, number_times)**

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. *