Counting text in a column?

[calem]

I wonder if there is a way to do something like this (which must be similar in principle to a word cloud).

I have a column in a sheet that contains a few hundred rows of service feedback text in sentence form. Is there a technique with existing formulas/functions to extract all words occurring in such a column with a count of the frequency?

Ideas would be appreciated!

[sandy666]

with Power Query (Get&Transform) split by spaces to rows then group and count

[63falcondude]

To add on to what Sandy said, you can remove all non-text (such as periods, commas, numbers, etc.) and also make the case uniform (upper, lower, proper) in Power Query as well.

This will ensure that all of the words are being counted appropriately.

[sandy666]

I agree with 63falcondude

here is a basic example from Washington Post

Result
src	Count
and	4
in	4
the	4
have	3
were	3
some	3
culture	3
who	3
of	3

Please Login or Register  to view this content.

single and double words were filtered out

[calem]

Thank you so much for the suggestion!

[sandy666]

You are welcome

[HansDouwe]

text in sentence form

Are there punctuation marks in the text that should be ignored? Or has the text already been cleared of punctuation marks?