REPT

Description

REPT repeats a text string the specified number of times.

Syntax

REPT ( text, number )

Parameter	Description
text	Any text string.
number	The number of times you want text to repeat. If number is 0, empty text (" ") is returned.

Remarks

The result of REPT cannot exceed 255 characters.

Example

This function returns error-error-error-:

REPT("error-", 3)

Note:

If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.