How to Count Words in Excel (Word Count per Cell)
Excel has no word-count function, so people build a LEN and SUBSTITUTE formula that miscounts the moment there's a double space. Add an accurate word count for every cell in one click.
Last updated: August 2026
| Text | Words | |
|---|---|---|
| the quick brown fox | → | 4 |
| hello world (double space) | → | 2 (counted right) |
Why the word-count formula miscounts
With no built-in function, the usual trick is =LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1 — count the spaces, add one. It's fiddly to type and, worse, it's wrong whenever a cell has double spaces or leading and trailing spaces: each extra space inflates the total, so the count quietly drifts off across the column.
The 1-click way — Tellsheet's Count Words
Select the column and run Count Words. Tellsheet adds a new column with the word count of every row's first cell, handling double spaces and edge spaces correctly, written as a real number you can sort and total. There's no LEN/SUBSTITUTE formula to write or debug, and your text is left untouched. Pairs with Count Characters and Remove Extra Spaces.
Frequently asked questions
Does Excel have a word count?
No — people approximate it with a LEN/SUBSTITUTE formula that miscounts on double spaces. Count Words adds an accurate count in one click.
Does it handle double spaces?
Yes — that's exactly where the formula fails. Count Words handles double, leading, and trailing spaces so the total is right.
Where does the count go?
Into a new column beside your text, holding each row's word count.
Is it a real number?
Yes — an ordinary number you can sort, filter, and total, not a live formula to convert.
Related Excel guides
Count words without a fiddly formula
Count Words adds an accurate per-cell word count in one click — double spaces handled, a real number, no formula to debug.
Get Tellsheet free See pricing