LEN returns the count of characters in a text string: Space characters are included in the count: LEN also works with numeric values, but number formatting is not included: The LEN function often appears in other formulas that manipulate text in some way. For example, it can be used with the RIGHT and FIND functions to extract text to the right of a given character: FIND returns the position of the character, which is subtracted from length, calculated with LEN. RIGHT returns the text to the right of that position.  Full explanation here.


LEN returns the length of text as a number. LEN works with numbers, but number formatting is not included. LEN returns zero if a value is empty.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.