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