REPT

Repeats a text-string a given number of times.

Syntax

REPT(text-expression,count)

Arguments

text-expression Text or cell reference to repeat.
count Number of times to repeat the text.  Must be between 1 and 1000.

Example

REPT("*",20) returns ********************