finding certain characters within a string within multiple cells

[Gav !!]

Hi Folks, I am hoping someone can put me straight on this one. In the cells
listed within the array below I want to look to see if the word forfeit
appears anywhere in the cell. For looking at one cell this formula works
fine
=IF(MID(AJ11,FIND("for",AJ11,1),7)="forfeit","Yes","No")

but to try and do it an a larger scale, hmmmm doesn't want to play. Here is
what I was trying. If anyone wants to take a crack at it, it would be much
appreciated.

=IF(MID("{C9,E9,G9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9}",FIND("forfeit","{C9,E9,G
9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9}",1),7)="forfeit","Yes","No")

Regards

Gav !!

 

[Frank Kabel]

Hi
if you want to check if this word is somethere in teh range try
=IF(COUNTIF(A1:A100,"*forfeit*")>0,"Yes","No")