Repeat String [REPT]

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

*-*-*-

  • Was this Helpful ?
  • YesNo