REPT Function
The REPT function repeats the given text number of times mentioned by the user.
Formula:
=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.
