Excel Count Characters in Cell: Formulas That Actually Work
If you need to count characters in Excel, the fastest answer is the LEN function. Put =LEN(A2) in another cell, press Enter, and Excel returns the total number of characters in A2, including spaces and punctuation.
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(cell) to count characters in one cell. For example, =LEN(A2) counts everything in A2. Excel's LEN function counts letters, numbers, punctuation, and spaces, which is why it is the right starting point for almost every character-count task in a spreadsheet.
If you want a fast cheat sheet, use the formulas below:
| What you want to count | Formula | What it does |
|---|---|---|
| All characters in one cell | =LEN(A2) | Counts letters, numbers, punctuation, and spaces |
| Characters without spaces | =LEN(SUBSTITUTE(A2,"  Shorten spreadsheet copy faster with QuillBotParaphrase, summarize, and polish text after you find over-limit cells in Excel. Try QuillBotHow to count characters without spacesIf you want the count without spaces, use =LEN(SUBSTITUTE(A2," Need shorter text after you count it?Use QuillBot to tighten long cell content before you paste it back into Excel. Use QuillBot |
