Long time reader, first time poster
What I am trying to achieve is a word cloud visualisation of customer feedback from survey data that is exported in .csv. I found this to achieve the word cloud: http://chandoo.org/wp/2008/04/…louds-in-excel-using-vba/
So what I need to get is a count of the various words in the survey data to get that to work.
What I have is a file with many hundreds of cells with various lengths and numbers of sentences in individual cells. Using text to columns I could get thousands of cells across a worksheet with individual words but I dont know how to get that in to something usable for the above script.
Thanks for any help