With string in A3 and name to count in B1, try this:
=(LEN(A3)-LEN(SUBSTITUTE(UPPER(A3),UPPER(B1),"")))/LEN(B1)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Chris the researcher" <Chris the
wrote in message ...
I need to count the number of times a word shows up in a given cell for
which
the number will then show up below the name of the word.
ex. B1
[Jon]
A3 ? How many times did
Jon appear?
[Jon, Kate, Jon, Lilly]
I want excel to put in a number where the ? is.
Please help!