Excel Number of Characters in a Cell: LEN Formula, Range Totals, and Limits
If you want the Excel number of characters in a cell, the fastest answer is the LEN function. In one formula, you can see how much text is in a cell, check whether an entry is too long, and build simple character-count workflows for content, data cleaning, or QA. ([Microsoft Support][1])
Disclosure: This page contains affiliate links. If you buy through them, we may earn a commission at no extra cost to you.
Quick answer
Use =LEN(A2) to count the characters in cell A2. LEN returns the number of characters in a text string, and in Excel that count includes letters, numbers, punctuation, and spaces. ([Microsoft Support][1])
If you need more than the one-cell answer, here are the formulas most people actually need in practice. They cover the main search intent behind this topic: a single-cell count, totals across cells, counts without spaces, counts of a specific character, and rules that stop people from typing more than a set number of characters. ([Microsoft Support][2])
| Task | Formula or action | What it does |
|---|---|---|
| Count characters in one cell | =LEN(A2) | Returns the total characters in A2, including spaces. |
| Total characters in a range | =SUM(LEN(A2:A6)) | Adds the character count for each cell in the range. |
| Exclude spaces | =LEN(SUBSTITUTE(A2,"  Shorten over-limit text with QuillBotOnce Excel shows which cells are too long, rewrite them faster with paraphrasing, grammar, and summarizing help. Try QuillBotHow to count characters in one Excel cellThe standard formula is =LEN(A2). Enter it in another cell, press Enter, and Excel returns the character count for A2. Microsoft notes that LEN counts spaces too, including spaces after the last visible character, so copied text can look shorter than the result suggests. ([Microsoft Support][1])
This works well for checking ad copy, product titles, imported records, or any workflow where text has to stay under a cap. When the result looks wrong, the cause is often hidden spaces, punctuation, or line breaks that LEN is correctly counting. ([Microsoft Support][2]) How to count characters across multiple cells or a rangeIf you want a total for several cells, Microsoft shows LEN combined with SUM. For separate cells, that can look like =SUM(LEN(A2),LEN(B2),LEN(C2)). For a continuous range, Microsoft's array formula example uses =SUM(LEN(A2:A6)) to add every character count together. ([Microsoft Support][2]) This is useful when a paragraph is split across cells, when you import CSV text into multiple rows, or when you want a batch total before exporting content somewhere else. In modern Excel, range formulas are easier to work with than they used to be, but the underlying idea stays the same: LEN measures each cell and SUM adds the results. ([Microsoft Support][4]) How to count characters in Excel without spacesIf you need the count without spaces, remove the spaces first and then count the remaining characters: =LEN(SUBSTITUTE(A2," Mistakes to avoid
FAQWhat formula counts the number of characters in a cell?Use =LEN(A2). It returns the number of characters in the text string in A2, including spaces. ([Microsoft Support][1]) How do I count characters in a whole range?Microsoft's array formula example uses =SUM(LEN(A2:A6)) to total the characters in a range. ([Microsoft Support][4]) How do I count characters but ignore spaces?Use =LEN(SUBSTITUTE(A2," Measure first, rewrite secondUse LEN to spot the problem, then use QuillBot when you need a shorter draft that keeps the meaning. Try QuillBot |
