How do I count all three-letter words in an Excel range?

Use =COUNTIF(range, '???'). Each ? matches exactly one character, so ??? matches cells containing exactly three characters.

Can I count words of different lengths using the same approach?

Yes - use two, four, or more ? wildcards to match words of those exact lengths. For example, =COUNTIF(range, '?????') counts five-letter words.

Can this method count words within sentences, or only exact-match cells?

COUNTIF with wildcards checks entire cell content. For cells containing complete sentences, use a LEN/SUBSTITUTE array formula to count words of a specific length within longer text.

Count Words by Character Length in Excel

If you wanted to find out how many words in a given range had a certain number (say 3 letters) the formula below would come in handy. = COUNTIF([range], "???") This formula combines =COUNTIF function ...

If you wanted to find out how many words in a given range had a certain number (say 3 letters) the formula below would come in handy.

=COUNTIF([range], "???")

This formula combines =COUNTIF function with wildcard characters ("?") to respond to your query. You can vary the number of wildcards in the formula to match the number of characters in the words you are looking for, for instance, if you were looking for the number of words with 4 letters, 5-letters, or more.

This formula checks out in the sanity check as shown below:

Count Words of a Specific Length in an Excel Range Using COUNTIF

Frequently Asked Questions