REPT function

REPT(text, number) REPT(text; number)

text — Text or { Text }

The text to be repeated.

number — Number or { Number }

The number of times the text string should be repeated.

Returns — Text or { Text }

The resulting text string.

Repeats a given text string a certain number of times and returns it.

Examples

REPT("x", 4)REPT("x"; 4)

Returns "xxxx".

REPT({ "x", "a" }, 4)REPT({ "x"; "a" }; 4)

Returns the array { "xxxx", "aaaa" }{ "xxxx"; "aaaa" }.

REPT({ "x", "a" }, { 4, 8 })REPT({ "x"; "a" }; { 4; 8 })

Returns the array { "xxxx", "aaaaaaaa" }{ "xxxx"; "aaaaaaaa" }.