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:

Argument Description
text The data to be repeated.
number_time A 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