Spread Formula Reference
REPT
Formula Functions > Functions R to S > REPT

This function repeats text a specified number of times.

Syntax

REPT(text,number)

Arguments

This function has these arguments:

Argument Description
text Text you want to repeat
number Number of times you want to repeat the text; if not an integer, the number is truncated; if zero (0), returns empty (" ")

Remarks

The result of this function must be less than or equal to 255 characters.

Data Types

Accepts string data for the text argument and numeric data for the number argument. Returns string data.

Examples

REPT(D9, 2)

REPT(R9C4, 2)

REPT(""*4"", 3) gives the result *4*4*4

Version Available

This function is available in product version 1.0 or later.

See Also

CONCATENATE | Text Functions