Rept Excel Formula




Excel Formulas > Text Functions > REPT

« Proper | Rept | Substitute »

What is the use of Rept formula?

Repeats a particular text n number of times


Syntax of Rept formula:
rept(this text, this many number of times)

Examples of Excel Rept formula:
rept("|",5) = |||||
rept("And", 2) = AndAnd

Buy Excel Formula E-book | Learn more about Excel Rept Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook