Use this normally entered formula...

=COUNTIF(B2:B5,"*"&E1&"*")

--
Rick (MVP - Excel)


"N1KO" wrote in message
...
Hi,

Is there any code to find a phrase (that i enter into cell E1) within a
cell.

For example if

B2 holds "The Cat in the hat"
B3 holds "The Cat in the Car"
B4 holds "The Dog in the Bush"
B5 holds "Harry and the monkey"

I want to search for the number of cells that hold the phrase "in the". In
this case that'd be 3

Is it possible to do this?

Thanks in advance

Niko