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" }.