Excel Function : REPT
Category
Text
Description
Repeats text a given number of times
Microsoft Excel Reference Page
https://support.office.com/en-us/article/REPT-function-04c4d778-e712-43b4-9c15-d656582bb061
Syntax and Description of the REPT Excel Function
=REPT(Text,number_times)
About REPT Excel Function
The REPT function in Excel returns a string consisting of a given string repeated a given number of times. For example, the formula =REPT("ab",3) returns the string "ababab".