How it works.
LEN counts the number of characters in a string, including letters, numbers, punctuation marks, special characters, and spaces.
💡 In simple terms.
Counts the total number of letters, numbers, spaces, and symbols inside a text cell.
Analogy
"Think of this like counting letters in a word. If you count the letters in "Apple", you get 5."
Syntax guide.
=LEN(text)
Parameters
textRequired
The text whose length you want to find. Spaces are counted as characters.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Generated Output
Best Practices
- Combine LEN with SUBSTITUTE to count occurrences of a specific character within a cell (e.g. `=LEN(A2) - LEN(SUBSTITUTE(A2, "e", ""))` counts the number of "e"s).
- Numbers are automatically converted to text strings and their digits counted.
Common Gotchas
- Leading or trailing spaces will inflate the count. Clean the text using TRIM first if necessary.