The REPT Function is categorized under Logical
functions in MS Excel. The function will repeat characters/ text a given number
of times.
Syntax
=REPT(text, number_times)
Arguments
1. Text: This is the text we want to repeat.
2. Number_times: This is the positive number that specifies
the number of times to repeat given text.
Example