REPT function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• ARABIC
• ASC
• BASE
• BAHTTEXT
• CHAR
• CLEAN
• CODE
• CONCATENATE
• DECIMAL
• DOLLAR
• EXACT
• FIND
• FIXED
• JIS
• LEFT
• LEN
• LOWER
• MID
• PROPER
• REPLACE
• REPT
• RIGHT
• ROMAN
• SEARCH
• SUBSTITUTE
• T
• TEXT
• TRIM
• UNICHAR
• UNICODE
• UPPER
• VALUE

< Previous Page

Next Page >

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.

---

See Also

• CONCATENATE

• Text functions

• Functions listed alphabetically
• Functions listed by category