On Mon, 5 Sep 2005 04:01:02 -0700, "Tommy T" <Tommy
[email protected]> wrote:
>I have a colomn of alpha-numeric strings and need to count cells which
>contain phrase A or phrase B buried within them. This is driving me crazy,
>please help!
=COUNTIF(A:A,"*abc*")
or, if your string to search for is in a cell:
=COUNTIF(A:A,"*"&D2&"*")
--ron
Bookmarks