I want to parse words and get a count

Situation: I have open ended survey answers. I want to create blog content to address the most highly mentioned concerns. I need to go through the answers and find any word (i.e., I don't have any particular words in mind) and then get a count of the number of times that word occurs. (I expect I'll get the word 'the' 10 million times!)

If I can get one column to show me the word, and the second column to show me the Count, I can sort by count and get the info I'm looking for.

All of the survey answers are in one column. There are 39k rows, though I can reduce that to a statistically significant number. Maybe 500 rows?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!