Excel Hack 61: Count the number of three-letter words in a range
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