See my answer elsewhere. Pls do NOT multipost

--
Don Guillett
SalesAid Software

"DaveB" wrote in message
...
Can you please help me with some code:

I have 3000 +/- rows in my worksheet, with only one
column. In any row, if the word "INC" is present
a sentence, then in column two I want the word "CORP" to
appear. Thanks in advance.

DaveB