What is the use of LEN function?

Returns the length of the specified string.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


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 - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference