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”.

Examples

=REPT(“*”, 5) returns “*****”.

=REPT(“ha”, 3) returns “hahaha”.

=REPT(5, 3) returns “555”.