REPT


returns a text string which includes repetitions of another text string.

Syntax:

REPT(text, number)
returns number copies of text, joined together.

Example:

REPT("ha", 7)
returns hahahahahahaha!
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.






This page is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof