To use this function, choose Calc > Calculator.

Repeats text a specified number of times.

Syntax

REPT(text,number_times)

For text, specify the text or the column of text. For number_times, specify how many times to repeat the text.

Example

Column Calculator expression Result
C1 contains "A" REPT(C1,4) AAAA
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy