Excel Character Count: Formulas for Cells, Ranges, and Limits

Need a fast way to measure text in Excel? The simplest Excel character count formula is =LEN(A2). It tells you how many characters are in a cell, including letters, numbers, punctuation, and spaces. That makes it useful for checking title tags, product names, ad copy, metadata, form fields, and any spreadsheet column with a hard text limit.

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 characters in one cell. Use =SUMPRODUCT(LEN(A2:A10)) to count characters across a range. Use =LEN(SUBSTITUTE(A2,"

Rewrite long spreadsheet copy faster

Use QuillBot to shorten titles, descriptions, and other text after Excel shows which cells are too long.

Try QuillBot

How to count characters in Excel step by step

1. Count characters in a single cell

Click an empty cell next to your text and enter =LEN(A2). Press Enter, and Excel returns the number of characters in A2. This is the core formula behind almost every Excel character count workflow.

Use this when you want a live count beside product titles, meta descriptions, social captions, or any field with a fixed limit. Once the formula is in place, drag it down the column to calculate every row.

2. Count characters in multiple cells

If you want a count beside each row, copy =LEN(A2) downward. If you want one total for the whole range, use =SUMPRODUCT(LEN(A2:A10)). This is a practical choice when you need the total text volume in a batch of descriptions or keyword labels.

For modern Excel, some users also use =SUM(LEN(A2:A10)), but SUMPRODUCT is a safer cross-version option because it handles the array without extra steps.

3. Count characters without spaces

Sometimes the real limit ignores spaces. In that case, remove spaces inside the formula before counting: =LEN(SUBSTITUTE(A2,"

Fit tighter character limits

Shorten text with QuillBot

Mistakes to avoid

Assuming LEN ignores spaces: it does not. Standard spaces count as characters, and trailing spaces count too.
Using TRIM for exact audits: TRIM cleans text, which is helpful, but it changes repeated spacing. That is great for cleanup and bad for raw forensic counts.
Forgetting hidden import issues: pasted content from other tools can include odd spacing or non-printing characters that make counts look wrong.
Using full-column SUMPRODUCT formulas: a formula like =SUMPRODUCT(LEN(A:A)) can be slower than a bounded range such as A2:A5000.
Checking counts without checking the destination: a spreadsheet count is only half the job. You still need to know the actual field limit where the text will be published.

FAQ

What is the formula for character count in Excel?

The basic formula is =LEN(A1). It returns the number of characters in the referenced cell.

Does Excel count spaces as characters?

Yes. LEN counts spaces, punctuation, numbers, and letters. If you need to ignore spaces, use =LEN(SUBSTITUTE(A1,"