Quick, clean, and to the point

Excel LEN Function

Excel LEN function

The Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included.

Get the length of text.
Return value 
A number representing the lengh of the text.
=LEN (text)
  • text - The text for which to calculate length.
Usage notes 
  • LEN is a useful when you want to count how many characters there are in some text.
  • Numbers and dates will also return a length.
  • Number formatting is not included. (i.e. the length of "100" formatted as "$100.00" is still 3).

Excel Formula Training

Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. See details here.

I find your site a fantastic resource. I have dramatically improved my Excel skills simply by looking at your emails and videos!
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course