find text in cell

B

Bonnie

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.
 
D

Dave Peterson

Instr is a VBA function.

You can use =search() or =find():

=if(isnumber(search("abc",a1),a1,"")

=find() is case sensitive.
=search() is not.

Another alternative (not case sensitive):

=if(countif(a1,"*abc*")>0,a1,"")
 
B

Bonnie

That's what I was looking for Dave. Thanks so much for your kindness in
taking the time.

Bonnie
 
Top