Excel 101: Basic Text Analysis and word clouds using pivot tables and other Excel tricks

This video shows how to combine individual text cells into one paragraph, parse cells with multiple words in to individual values, as well as create a word cloud using an external website (no affiliation).

[nigerianprince]

Nonchalant brilliance. Love the video mate. Very helpful

[ninonacario]

Hey man! I just got the best ever kudos at my job because of this! Thank you so much and you are so awesome!

[BeVal]

Firstly, and respectfully, sir, you have a very beautiful masculine voice. Secondly, thank you for the approach

[JCA]

Great video. I'm actually in an Excel file right now and used Word to make a word cloud out of the text in the spreadsheet. Will have to try this. Good speaking voice too, by the way.

[darrah]

Clever thinking. Appreciate the content!

[afkhoso]

this was new to me, glad i came across the video, but the stop words make it ... useless. im in dire need of having those removed to make sense of all my text, done a few searches but it's not easy/straight forward. there goes another afternoon of research, trial and error.

[imranansari-omjy]

nice video and really helpful, wish had a font size little bigger, would have been easy to read.

[piotr]

Well explained, thanks for sharing- just one downside of cell capacity limitation to 32767 characters

[chriscockrell]

How do I do this with grouping 2 words?

This uses space delimited separation of words. I’m interested in doing this with 2 or 3 words. Themes.

Notes:
Word Cloud
Data Tab, text to column, transpose, and pivot table.

[nehathacker]

thank you for posting this. How to do this with sentences in the row and with like a million data records? Need a paragraph but cell character limit sets in after 250 rows.

[KTsPridiction]

It is a great trick to analyse our data... If data is too much high then it will not be cover in single cell... Is there any option to enter n number of words in single cell

[sharminshila]

What is the formula you use around 4:36 into the video? and afterwards, what did you change in the formula?

[alexus]

When I paste the last row to a new sheet it doesn’t paste all the words from the text analysis. Did I miss a step or something? Any tips would helpful!

[ivopetrusa]

Hi! Very useful. I tried doing the same but I experienced a lot of words like "a, the, and, but" etcetera. Do you have a speedy way of excluding these words so only the useful words stay in the pareto or wordcloud?

[frankconte]

What is the formula you use around 49 seconds into the video?