Formulas and Functions

REPT
The REPT function returns a string value that contains a given string value repeated a specified number of times.
REPT(source-string, repeat-number)
source-string: Any value.
repeat-number: A number value specifying the number of times the given string should be repeated. repeat-number is a must be greater than or equal to 0.
Examples |
---|
=REPT("*", 5) returns "*****". =REPT("ha", 3) returns "hahaha". =REPT(5, 3) returns "555". |