Repeats a string a specified number of times.
Syntax
REPT (“Text”, NumberOfTimes)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Text: String
Number of times: Integer
Data Type of the Result
String
Example
Display an asterisk and a dash 3 times.
Expression
REPT (“*-”, 3)
Result
*-*-*-
Relevant topics
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position.
Syntax
REPLACE ...
Convert to String [STR]
Converts a non-unit numeric value or a True/False value into a string.
The resulting string shows two decimal places by default.
Syntax
...
Number from String [STRTONUM]
Extracts numerical character(s) from the initial position in a string.
(Only the beginning of the string is considered. Numerical characters ...