Repeat()

Home   Back   Next  

Working with Formulas > Functions Used in Formulas > Text Functions > Repeat()

 

REPEAT() repeats the characters in the input string until the specified length is reached.

 

 

Function Format

 

REPEAT(string , length) 

 

 

Return Value

 

REPEAT() returns a character string 

 

 

Examples

 

REPEAT("APPLE", 10) = "APPLEAPPLE" 

 

REPEAT("APPLE", 12) = "APPLEAPPLEAP"