Transpose each word in sentence into individual cells/Count the repeat words...???

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

Perfect shg, Will Review and See If I can figure it out...

I'll post it here once I conquer!

Please Login or Register  to view this content.

Originally Posted by Marc L

Please Login or Register  to view this content.

I have option explicit on...

What would I declare T$ as?

it won't allow me to declare it as anything...

Please Login or Register  to view this content.

Originally Posted by Marc L

Please Login or Register  to view this content.

Can you break down what is happening here?

Originally Posted by shg

There's a workbook that tabulates phrase densities at https://app.box.com/s/ceurmq61hsdg8a6vn5nv

That's Freaking Bananas!
Nice! Im surprised that macro doesn't count vowels hahaha

Cool Stuff, thanks

swade730

Option Explicit.

Good.

Don't even try to copy the code that is not declare the variable properly.
It will be risky sometime.

Originally Posted by swade730

Im surprised that macro doesn't count vowels hahaha

Here's an alternative.

Please Login or Register  to view this content.

jindon, a master blaster code for compound words like "NEW YORK Reuters"

but word "week" is in duplicate and 10 little words are missing :

a - as - been - in - it - its - of - on - the - to …

They are excluded from the string for analysis.

Yes I saw that in Pattern statment, a strain from regular expressions ?

OK, thanks for pointing that out.

Here's a code

Please Login or Register  to view this content.

Originally Posted by jindon

Here's an alternative.

Please Login or Register  to view this content.

This one works
funny-Jim-Carrey-car-screaming.jpg

In an effort to better understand the code, I have added comments.

the .property part of the code is most confusing. I've done some research and It's still not clear.

Can anyone explain the .property aspect in simpler words please?
And is "dic.keys" used to count the number of repeat words?

Please Login or Register  to view this content.

"dic.keys"
http://msdn.microsoft.com/en-us/libr...(v=vs.84).aspx

See also
http://msdn.microsoft.com/en-us/libr...(v=vs.84).aspx