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


example of ddlsql questions for freshersms access vba queryexcel pie chart examplesexcel vba sendmailchart wizard on excelprotect an excel workbookvb and excelpaste values vbaadodb.recordset openconcatenate formula in excelweekly report template pptcosting sheet templateexcel aptitude questionsexcel formula templatesexcel vba resizeexcel sorting macroword vba examplesmerge and center excel 2007learn macros in exceldeleting rows in excelexcel 2007 checkboxexcel nested vlookupms excel offsetvba worksheet selectvba excel referencehighlight duplicate entries in excelms excel macrosum if in excelvba delete columnexcel advanced tutorialworksheet select vbaunlocking excel passwordtesting interview questions and answers for experienced pdfsql projects for beginnersarrange numbers in ascending order worksheetsvba range selectado database connectionsample excel macro codedelete duplicates in excelvba select a worksheetvba screen updatevba count rowshyperlink to excel worksheetmacro visual basic excelsql query operatorsvba excel selectexcel vba languagedefine macro in excelpaste special skip blanksswot analysis excel templatecase statement in vbawhy vlookup is usedleft function vbaaccess vba insertfollow hyperlink vba excelchange the row height in excelmicro in excel 2007how to merge three columns in excellearn vlookup in excelconcatenation excelexcel mergingexcel 2010 unprotect workbookunlock protected workbooktutorial on excel pivot tablesexcel vba msgboxsimple vlookup formulaexcel vba scriptinghow to calculate trend analysis in excelisblank excelhow to create activex controlcreating a stock chart in excelexcel logical operatorms excel dashboard tutorialpivot tables for beginnersexcel macros tutorialexcel worksheet sampleserase vba