REPT (Primitive Spread Function) repeats text a specified number of times.

SYNTAX:

REPT(Text, Number)

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. 

EXAMPLES:

REPT(D4, 2)
REPT("*4", 3) equals *4*4*4