Count Words in an Excel cell
How to count the number of words in an Excel cell? With Excel, you can use 2 techniques to return this result.
words
Split your text on a delimiter – TEXTSPLIT Function
The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.