On Mar 8, 3:07 am, Gary''s Student
wrote:
The solution depends upon the organization of your data. For example, if you
have a single column of single words like:

Words
cat
dog
dog
fish
cat
dog
fish
fish
cat
dog
fish
fish
dog
dog
dog
cat
cat
dog
fish
cat
fish
dog
dog
dog
dog

Then a Pivot Table can give the count of each unique enter:

Count of Words
Words Total
cat 6
dog 12
fish 7
Grand Total 25

If your words are in paragraphs within cells, then a different approach
would be taken.

--
Gary''s Student - gsnu2007e


Thanks Gary. Yes my words are in paragraphs, what's the solution
then?