Search text field for word

[Guest]

Could someone help me with a formula to find the word Contractor in column AB
and have that word appear in the free column AC? This would be for a very
large worksheet so I'd drag the formula down. AB has text in it.
TIA,
GerryK

 

[Peo Sjoblom]

=IF(ISNUMBER(SEARCH("contractor",AB2)),"Contractor","")



--


Regards,


Peo Sjoblom

 

[JE McGimpsey]

One way:

AC1: =IF(COUNTIF(AB1,"*Contractor*"),"Contractor","")