Search text field for word

G

GerryK

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
 
P

Peo Sjoblom

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



--


Regards,


Peo Sjoblom
 
Top