How to use Rept Function in Excel?

Rept Function is used in excel to return a text or value repeatedly specified number of times.

Some times we need to repeat some text or value multiple times in excel. Rept is inbuilt function of Excel.

Syntax :
Syntax of Rept Function is below given.
Syntax : Rept(Text ,Number)

Arguments :

Text :The Text Value Which need to Repeat. It may be Text or Number.
Number :  The number times to repeat a value in Excel Cells.

You May Also Like to Refer : Digital marketing for political Election

How to use Rept Function in Excel?

Now we see how to use Rept Function in Excel with Example.

⊗ Open one Microsoft Excel Workbook .

⊗ Type Any Text or Number in Cell which is you want to Repeat.

⊗ Type Rept Function Syntax.

⊗ Press Enter

⊗If You have Multiple values in cells which you want to Repeat then Drag Formula till your requirement.

Now lets refer below given Images.

In Cell B2 we mention once text ABC which we want to Repeat 2 times .
So Syntax is =REPT( Text,Number)

Syntax : = Rept (B2,2)

So As we Press Enter ABC Will Repeat 2 times in Cell.

Same way if you want to Repeat any numbers in Excel then you have to mention Number in Cell .

Syntax : =REPT(Text,Number)

Thats it. REPT function is simply used like this in Microsoft Excel Workbook.

Function REPT Can be used in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000.

 

You May Also Like to Refer :http://www.mahipaldodia.in/earn-money-from-facebook-instant-article/
You May Also Like to Refer :http://www.mahipaldodia.in/how-to-view-infinite-search-result-in-google-chrome/
You May Also Like to Refer :http://www.mahipaldodia.in/how-to-type-same-data-in-multiple-cell/
You May Also Like to Refer :http://www.mahipaldodia.in/how-to-add-drop-down-list-in-excel/
You May Also Like to Refer :http://www.mahipaldodia.in/use-exact-function-excel/
You May Also Like to Refer :http://www.mahipaldodia.in/whats-app-going-to-limit-forward-messages/
You May Also Like to Refer :http://www.mahipaldodia.in/how-to-use-youtubes-new-incognito-mode-for-hide-history/
You May Also Like to Refer :http://www.mahipaldodia.in/how-to-check-short-url/
You May Also Like to Refer : http://www.mahipaldodia.in/android-application-development-junagadh/

 

 

 

(Visited 96 times, 1 visits today)