REPT Function in Excel

Home/Excel Formulas/REPT Function in Excel

What is the use of REPT function?

REPT function returns a repeated text value a specified number of times

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


What is the syntax of REPT function?

REPT Function in Excel Syntax

REPT( text, number_times )

Where
text : text value to repeat.
number_times: number of times to repeat the text value.

REPT Function in Excel – Examples

REPT Function in Excel Examples

 
 
Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |April 11th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


excel option button groupexcel vba range formuladelete duplicate data in excelexcel vba combobox rowsourcefind duplicates in spreadsheetautosave in excel 2007excel timeline project templatehlookhide excel sheet with passwordprotect excel sheetadd the developer tab to the ribbonhide worksheet in excellearn vbaexcel color templatevlookup excel 2007oledb connection string sql server 2012vba to unprotect sheet with passwordhow to delete multiple cells in excelexcel offset examplevba range selectionunlock protected excel workbooksum if in sqlhow do you unhide rows in excelexcel vba calculate sheettcl commandsduplicate function in excelunlock workbook excelproject charter template powerpointuse of vlookup and hlookupselecting a sheet in vbaexcel vba message boxfont color excel vbavba connection stringadodb parameterized queryunprotect sheet excel 2010microsoft excel functions tutorialprotect columns in excel 2007excel macro copy row to another sheetvba application.getopenfilenamevisual basic excel macrovba unprotectvba scriptadvanced functions in excelsql basic commandsmarketing gantt chart templatevlookup two worksheetsvlookup function excelactivecell.selectconcatenate in excel 2007vba rgb color codessql equality operatorsmacro recorder excel 2010recording macro in exceldim rs as recordsetexcel vba progress baradd radio button in excelhow to create a pivot chartifs in excelduplicate rows in excelfor each in vba excelwhat is the iferror function in excelscripting filesystemobject vbaexcel autofit columnssql for beginnersvba colorindexexcel exercises for beginnersvba upperunlock excel vba passwordproject tracker template excel freeexport data from access to excel using vbaworksheet activatemacro programming in excelapplication calculation xlcalculationautomaticexcel vba multiple ifunhide multiple sheetsactivecell.row