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 *****.