Documentation/How Tos/Calc: REPT function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• Base
• Char
• Clean
• Code
• Concatenate
• Dollar
• Exact
• Find
• Fixed
• Left
• Len
• Lower
• Mid
• Proper
• Replace
• Rept
• Right
• Search
• Substitute
• T
• Text
• Trim
• 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.

Template:Documentation/SeeAlso