Multiple time in just one cell?

=(LEN(A1)-LEN(SUBSTITUTE(A1,"the_word","")))/LEN("the_word")

or once per cell in many cells?

=COUNTIF(A2:A20,"*the_word*")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nwilson" wrote in message
...
can i count how often a word occurs in a cell that has more than one word
in
the cell???