In Word you can easily count the words simply by clicking “Word Count” from the Review ribbon. But what if you have your text in Excel? There is no built-in word count function in Excel, so we have to find another way.
In a previous post I showed how to count characters in a text string using the LEN function. We will use the same function, with a twist, to do a word count.