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.