Navigation:  Formulas and functions > Functions from A to Z > REPT (repeat text string)

Syntax:

REPT(Text, n)

Description:

This repeats the specified text string n times.

You use the argument n to specify the number of repetitions. n should be an integer. If this is not the case, Calculate automatically truncates the decimal places.

Example:

REPT("Text", 3) returns TextTextText

See also:

REPLACE, SUBSTITUTE