Do you need to count the number of cells containing "mrs" or every occurences
or "mrs", counting each occurences in every cell ?
--
Regards,
Luc.

"Festina Lente"


"ricowyder" wrote:

Hi group members,

After copying a large amount of text from a pdf (I unfortunately have
no other way to import those data), I need to count the appearances of
the string "mrs" in the whole worksheet. After trying several options,
I am desperate and would like to ask you for help.

Imagine all data togethe in a cell (all text, sometimes figures).
I now want to count the string "mrs" within this string, but not only
in one cell, but in all cells.

Thanks a lot, if you would help me with this.

Cheers,

Rico