REPT

---

Name

Repeat

Description

Repeats text a specified number of times.

Syntax

REPT(Text, Number)Remarks

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.

Data Type

Accepts string data for the Text argument and numeric data for the Number argument. Returns string data. For more information, see Data Type for Each Cell Type.

Example

REPT(D4, 2)
fpSpread1.Formula = "REPT(""*4"", 3)" equals "*4*4*4"