Using the Excel REPT Function

Summary
The Excel REPT function will repeat text a given number of times. For example, =REPT("*", 3) would produce ***.Syntax
=REPT (text, number_times)Syntax Breakdown
TextRequired. The text you want to repeat.
Number Times
Required. The number of times you want to repeat text. This argument must be a positive integer. Non-integer numbers will be truncated.
The function returns "" (empty text) if number times is 0 (zero).
Usage Notes
The REPT function will repeat text a given number of times. The function is useful if you need to fill a cell or pad values to a specified length.#VALUE! Error
The function will return the #VALUE! error if the output is longer than 32,767 characters.