Word frequency within text strings

[BigRuss]

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!

[Inactive User · Accepted solution]

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?