How to use REPT function in EXCEL 2016

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

1 Response