Skip to main content

REPT function

The REPT function is one of the text and data functions. Is used to repeat the data in the selected cell as many time as you wish.

Syntax​

REPT(text, number_time)

The REPT function has the following arguments:

ArgumentDescription
textThe data to be repeated.
number_timeA number of times you wish to repeat the data you entered.

Notes​

How to apply the REPT function.

Examples​

The figure below displays the result returned by the REPT function.

REPT Function