Are they all single words per cell or is it more of a sentence per cell? If
they are just single words you can use this function:

Assume your range is A1:A100
=countif(A1:A100,"<word you want to search for")/COUNTA(A1:A100)

--
Regards,

DavidB


"Rebecca" wrote:

How can I get the total number and percentage of for each different
word in a column which has several word descriptions? What function do
I use?