REPT

See also A-Z Spreadsheet Function List

Description Repeats a text string the specified number of times.

Syntax REPT(text, number)

text is any text string.

number is 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 REPT(“error-”, 3) returns “error-error-error-”