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.

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.

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,"")



Bonnie wrote:

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.

--

Dave Peterson

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

Bonnie


"Dave Peterson" wrote:

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,"")



Bonnie wrote:

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.

--

Dave Peterson