REPT Function in Excel – Repeat the string in Excel

REPT Function in Excel repeats the string for a specified number of times

Syntax of REPT Function in Excel (Repeat Function):

REPT( text, number_times )

Where,

text –Text String to be repeated
number_times – number of times the text string to be repeated.

Example of REPT Function in Excel (Repeat Function):

Formula

REPT Function in Excel 1

Excel REPT Function, takes the text string and the number of repetition as arguments
In Row number 5 the number of repetition is 0 so REPT Function returns the empty string.
From Row number 2 to 4 the REPT Function repeats the strings to the specified number of times.

Result:

REPT Function in Excel 2