Word frequency within text strings

I have a csv file with a number of records with paragraphs of text stored as free text strings and I would like to search across all the entries in the column and produce a frequency table of the most used words within all the records

The effect I'm looking to obtain is similar to a word cloud with the most frequently used words given prominence.

I considered splitting the paragraphs up using the spaces as delimiters but that seems very messy. Anyone got a better way?

thanks!

Transformation

Accepted answers

unknown

Transpose to Rows and then use Text to Columns and Split to Rows on spaces. Then, summarise tool on the value by using Group By and Count.

All comments

unknown

Transpose to Rows and then use Text to Columns and Split to Rows on spaces. Then, summarise tool on the value by using Group By and Count.

BigRuss

Perfect, thank you!

nimit_b19

Can you please elaborate with words or with a dummy file?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703