[Jon, Kate, Jon, Lilly]

Do the brackets appear in the cell?

Are the names always separated by commas?

--
Biff
Microsoft Excel MVP


"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!