Forum Discussion
Solved
excel split text into 1 column
how do i select a range of many words and sentences and split the text into each and every word and then sort all of them into 1 column and then count the frequency that each word is used like a glos...
do this for all your columns:
When you're done
Do a power query on each of the two columns in the image above, load as a connection
when you have done all the queries on all letters, do an append query on all the queries so they'll all be in one column. Keep in mind that excel has a limit of 1 million rows so you might have to break them up by alpha/numeric segments.
cheers
