Excel Function : REPT

Download now!

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