Hello,
My objective is to...
1. Take like a the words in a single cell.
2. Put them into individual cells with a macro. (i.e. transposed to columns)
-But the recorder does it with each of the words using arrays.
(what if its a different sentence/paragraph) that I separate; The arrays would change.
3. Then once each word is in it's own column, Take the whole Row, Make it into a column
4. Then Some how count how many times each word appears.
I tried doing this step by step but I am attempting to look for a cleaner way to do it.
Attached you'll find a spread sheet and the paragraph in cell A1 is the paragraph I want to chop and count.
Any assistance would be appreciated. Thanks
Bookmarks