Hi,

This isn't clear what you want so we'll start with this.

=COUNTIF(A1:A30,"The")

Mike

"rrupp" wrote:

I have a user who has imported survey results into Excel. He wants to do a
word count for each possible word. So he wants to know that the word "the"
appears 145 times and the word "chicken" appears 345 times. Is there an easy
way to do this. Very odd question, I know and I cannot figure out a way to
do it. I know how to count a specific word but not every word possiblity that
appears in the cell.

thanks for your time.