Documentation/How Tos/Calc: REPT function

REPT

returns a text string comprised of copies of another text string.

Syntax:

REPT(text; number)

returns number copies of text, joined together.

Example:

• REPT("ha"; 3)

returns hahaha.

• REPT(ROUND(RAND()*10); 3)

returns nnn where n is a random digit repeated three times, while:

CONCATENATE(ROUND(RAND()*10); ROUND(RAND()*10); ROUND(RAND()*10))

returns xyz where x, y, z are three randomly independent digits.