REPT

The REPT function repeats text a specified number of times.

Syntax

=REPT(text, number_times)

Parameters

• text: The text to repeat
• number_times: The number of times to repeat the text

Examples

=REPT("*", 5) // Returns "*****"
=REPT("AB", 3) // Returns "ABABAB"
=REPT("-", 10) // Returns "----------"