How to use REPT function in EXCEL 2016

Last modified date

How to use REPT function in Excel 2016

REPT function will give us the option to repeat a particular text for the required number of times in one cell.

REPT function in Excel
Description of REPT function in Excel

The Syntax of REPT functions

1st Argument (compulsory Argument) here we need to give the Text which we want to repeat.

2nd Argument (compulsory Argument) here we need to give the number. This number is how to times you want to repeat TEXT already given in the 1st argument.

Syntax of REPT Function In Excel
Syntax of REPT Function Excel

Application of REPT function

C3=$$Free

E3=REPT(C3,5)

Application REPT Function in Excel
Application of REPT function in Excel

Click here to get the Sample copy

6 Responses

    • Thanks for following my website and learning how to use REPT function in excel. You can also learn How to Use Excel Vlookup and Excel Pivot table and other Excel functions.

    • Thanks for following my website and learning how to use REPT function in excel. You can also learn How to Use Excel Vlookup and Excel Pivot table and other Excel functions.

  1. Thank you Commerce and Excel hub. Today I have learned REPT function in excel and it is really helpful for me on my day to day work. I see this website is the best online excel training platform.

    • Thanks for following my website and learning how to use REPT function in excel. You can also learn How to Use Excel Vlookup and Excel Pivot table and other Excel functions.

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment