REPT Function
Repeats text a given number of times.
Syntax
REPT (text, number_times )
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
text |
Required |
String |
The text you want to repeat. |
number_times |
Required |
Number |
A positive number specifying the number of times to repeat text. |
Remarks
If number_times is:
Zero (0), REPT returns "" (empty text).
Not an interger, it is truncated.
Example
REPT ("*", 5)
Returns *****.