Did you bother to look in the vba help index for INSTR

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bonnie" wrote in message
...
Hi,

I am trying to do something like this:

if(instr("ABC",A1),A1,""))

Doesn't work? If ABC is found in A1 I would like to copy A1 to B1 (leave
B1
blank if not).

Thanks in advance for any help you can give.