REPT Function

The REPT function repeats the given text number of times mentioned by the user.


=REPT(Text to be repeated, Number of times)
If the number of times is given as 0, then the function returns empty text.
If it is a decimal number, it ignores the decimal portion of the number.
If the result is longer than 32767 characters, the function returns #VALUE!

Video Tutorial:

Let us learn how to repeat the given text, using the REPT function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question