Hello all!

Is there a way to make a simple text analyser that will return the number of times each word is used in a sentence or paragraph within a cell?

I use excel to write short paragraphs to upload onto social network sites and I would like a formula or program that tells me how many times each word has been used over a number of cells, to avoid repetition. Is there a way to do this?

Thank you

Dave