Rept

Syntax

Rept(Text, Number_times)

Text. String to repeat.

Number_times. Number of times the input string should be repeated.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns a string repeated for the specified number of times.

Formula	Result	Description
=Rept("Za", 2)	ZaZa	The Za string repeated twice.
=Rept(B6, C6)	XXX	The string in the B6 cell repeated by the number of times specified in the C6 cell. The B6 cell contains the value X, the C6 cell contains the value 3.