Excel Character Count: Formulas for Cells, Ranges, and Limits
The simplest Excel character count formula is =LEN(A2). It measures a cell’s text, including letters, numbers, punctuation, and spaces. Use it beside product names, captions, or other fields with a length requirement.
Disclosure: This page contains affiliate links. If you buy through them, we may earn a commission at no extra cost to you.
Quick answer
- One cell:
=LEN(A2) - Range total:
=SUMPRODUCT(LEN(A2:A10)) - One cell without ordinary spaces:
=LEN(SUBSTITUTE(A2," ",""))
Examples use English function names and commas. Depending on your Excel language and region, you may need translated function names or semicolons.
Rewrite long spreadsheet copy faster
Use QuillBot to shorten titles, descriptions, and other text after Excel shows which cells are too long.
Try QuillBotHow to count characters in Excel step by step
1. Count characters in a single cell
Click B2, enter =LEN(A2), and press Enter. Fill the formula down to count each row. Spaces at the beginning and end count too.
2. Count characters across a range
Use =SUMPRODUCT(LEN(A2:A10)) for a combined total. With Red in A2 and Blue in A3, =SUMPRODUCT(LEN(A2:A3)) returns 7. The formula adds lengths without inserting a separator between cells.
A helper column makes the individual counts visible: enter =LEN(A2) in B2, fill through B10, then total them with =SUM(B2:B10). Fix any error values in the source cells before trusting the total.
Use a bounded range such as A2:A5000 instead of a full column. Microsoft’s SUMPRODUCT guidance recommends avoiding full-column references for performance.
3. Count characters without ordinary spaces
Use =LEN(SUBSTITUTE(A2," ","")). SUBSTITUTE replaces each ordinary space with empty text, and LEN counts the result. Hello world! returns 11 instead of 12. Tabs, line breaks, and nonbreaking spaces remain. See SUBSTITUTE syntax.
4. Count after cleaning repeated spaces
Use =LEN(TRIM(A2)) when you intentionally want to measure text after trimming. TRIM removes leading and trailing ordinary spaces and collapses repeated internal spaces to single spaces. It does not remove every space or, by itself, remove nonbreaking spaces. Keep the raw =LEN(A2) result if you need an exact count of the original text. See Microsoft’s TRIM explanation.
5. Flag cells that exceed a limit
Put your destination’s limit in D1, such as 50 for a field that allows 50 characters. Enter =IF(LEN(A2)>$D$1,"Over limit","Within limit") beside each row. Use =$D$1-LEN(A2) to calculate remaining capacity; a negative result shows how many characters must be removed.
The number in D1 is your chosen field limit, not a universal search-engine rule. Recheck text after editing and in the destination itself.
Fit tighter character limits
Review suggested wording, then count the final text again.
Shorten text with QuillBotMistakes to avoid
- Assuming LEN ignores spaces: ordinary and trailing spaces count.
- Using TRIM for an exact audit: it measures a cleaned version, which may differ from the original.
- Overlooking imported characters: pasted text may include line breaks or nonbreaking spaces.
- Using full-column SUMPRODUCT ranges: limit the formula to the rows you need.
- Assuming every visible emoji counts as one: Unicode sequences and workbook compatibility settings can affect the count.
FAQ
What is the formula for character count in Excel?
Use =LEN(A1) for one cell. Microsoft’s LEN reference explains the function and Unicode behavior.
Does Excel count spaces as characters?
Yes. To exclude ordinary spaces, use =LEN(SUBSTITUTE(A1," ","")). To keep single word separators but remove excess ordinary spacing, use =LEN(TRIM(A1)) instead.
How do I count multiple cells?
Fill LEN down for a count per row, or use =SUMPRODUCT(LEN(A2:A10)) for one total. A helper column plus SUM is another clear option. Microsoft’s guide to counting characters also demonstrates individual counts and totals.
If you need to count occurrences of a particular character, see our single-cell formula examples.