LEN Function in Excel

Home/Excel Formulas/LEN Function in Excel

What is the use of LEN function?

Returns the length of the specified string.

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 LEN function?

LEN Function in Excel syntax

Len(text)
Where Text : The text string you want to find the length of.

Note:Any Blank spaces in the text string will consider as individual characters.
If text string contains blank, it will return null value.

LEN Function in Excel – Examples

LEN Function in Excel Examples

LIMITED TIME OFFER
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


recording macrosvbscript programs exampleshow to use the pivot table in excel 2007excel unprotect without passwordmsgbox hello worldswitch between sheets excel shortcutvba comboboxassign macro to data validation listbeginners sql tutorialworksheets vbavba word userformexcel function iserrorexcel vba sql connectionnested if functions in excel 2010excel vba loop through rowsexcel macro worksheetexcel macro selectionmerge multiple worksheets into oneexcel formulas sumifcreating pivot tables in excel 2007vba multidimensional arrayhow to save excel macroconsolidate multiple excel sheets into onehow to unprotect excel sheet 2010programming excel with vbaexcel vba refresh pivot tablehow to insert multiple row in excelexcel 2010 autofit row heightcreate vlookup excel 2010how to unhide row in excelexcel vba advanced tutorialproject timelines templateshow to bring up vba in excelcolor function in excel 2010task tracking template excelopen file vba excelunload userformexcel check for duplicatesvba in wordcombo boxes in excelmatch formula in excel with examplevba pop up boxsumif excellvba update recordsetexcel vba programming for dummies free downloaddelete file using vbscriptcombine data from multiple workbookssave excel vbaexcel vba insert row into tablewrite a function in vbacolor excel cellsexcel 2003 lookupvba open a filemacro in excel 2007 tutorialdeduplicate in exceldata modeling interview questions and answers pdfnumber of rows in excel 2007sum if excelunprotect excel macrovba msgbox yes novlookup in excel 2010 examplehow can i merge cells in excelhow do i unhide columns in exceltechnical aptitude test questions and answersfso folderexcel vba manualcase syntax vbaexcel line graph templatesformula to find duplicate values in excelsql dml statements examplesexcel macro columnexcel macro format cellwhat is countif function in exceldefine activex controloffset formula in excelexcel macro pasteexcel 2007 vba pdf