find text in cell
 

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.

find text in cell
 

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.

find text in cell
 

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

find text in cell
 

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