In cell E1:

=COUNT(FIND("in the",B2:B5))

Enter as an array formula (control-shift-enter)

Note that this is case sensitive, and will not match "In the" or "in The"

HTH,
Keith

"N1KO" wrote:

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