Repeat()

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"