REPT
Name
Repeat
Description
Repeats text a specified number of times.
Syntax
REPT(Text, Number)Remarks
Remarks
Arguments are as follows:
| Argument | Description |
|---|---|
| Text | Text you want to repeat. |
| Number | Number of times you want to repeat the text. |
Note the following about the Number argument:
- If Number is 0, REPT returns " " (empty text).
- If Number is not an integer, the result is truncated.
The result of the REPT function must be less than or equal to 255 characters.
Data Type
Accepts string data for the Text argument and numeric data for the Number argument. Returns string data. For more information, see Data Type for Each Cell Type.
Example
REPT(D4, 2)
fpSpread1.Formula = "REPT(""*4"", 3)" equals "*4*4*4"