Counting words in multiple sentences

Try this for results in columns "B" & " C".

Please Login or Register  to view this content.

Regards Mick

Thanks for the nice macro, Mick.
It does the job!
When I looked at the results I realized that it will be a lot more useful if:

1. The macro will filter out the question mark sign (?)
at the moment LICE and LICE? are counted as two different words, I need to remove the ? sign from the calculations and count the total amount of instances of each word into a single result.
2. there are 29 words that needs to be excluded from the results, see text file attached.

Thanks again,
Sami

Originally Posted by MickG

Try this for results in columns "B" & " C".

Please Login or Register  to view this content.

Regards Mick

BINGO!
Thanks a lot, Mick!
Sami

Originally Posted by MickG

Try this:-
Nb:- Add to "Excluded" words list as required.

Please Login or Register  to view this content.

Regards Mick

You're welcome

Try this modified code , I'm afraid it was my Fault again another typo in last line.