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

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!

See details.

Many thanks.This site is pinned to my home page and has proven itself very useful. - Glynn
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