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


iserror vbacount identical cells in excelpower vbavbscript conditional statementsexcel vba copy worksheet to another workbooksave vba excelsave excel file vbahow to create userform in excel vbaexcel vba conditional statementsvba data entryexcel datevalue functionfree gantt charts in excelcheckbox en excelsas macros tutorialhow to create check box in exceloffset function excelmaking dashboards in excelms sql interview questions and answers pdfcool vb scriptshow to use hlookup functionproject spreadsheet template excelunprotect a workbookvb net excel set column widthhow to add developer tab to the ribbon in wordexcel usedrangehow to merge three columns in excelhow to do vlookup on excel 2010deleting rows in exceldata analysis for dummiesvlookup meaninghow to disable a macro in excelactivex combo boxexcel vba color cellhide duplicates excelsubstitute function in excelexcel vba convert column number to letterasap utilities 64 bit downloadadd drop down in excel 2007excel dim as rangedefine excel macrohow to find duplicate rows in excelexcel 2010 vba progress barhow to do vlookup on excel 2010vba excel tricksresource allocation template excel freesample meeting minutes template wordexcel merge sheets into oneadvanced filter macroapplication.worksheetfunctionfunctions vbavba print sheetexcel unprotect sheet commandapplication.screenupdatingunprotect excel vba codevba excel macroshide cells in excelpivot tables in excel 2003pivot table in sql server 2008excel if statement with 2 conditionsvba downloadsvba excel form controlshow to unhide all rows in excelword dashboard templateexcel unlock sheetexcel pivot tables advancedvba save as dialogexcel formulas pdf with example 2007 in hindivlookup between workbooksdrop down list in excel 2007vba buttonsvba excel databaseexcel macro recordexcel vba codeshow to sort excel sheets alphabeticallyadvanced excel formulas with examplestask tracking template excel