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