Search for string of characters in a cell
 

Hello,
I need to search for a string of characters in a cell and plave a "1" in
another cell if the string exists, such as:
If the string "HW0" appears I need to put a 1 in adjacent cell

A B
HW0233 1
hw0
apple

dog
HW03 1

I tried =find("HW0",A1,1), but if the cell is empty it returns #VALUE.

Help is appreciated.

Search for string of characters in a cell
 

Try this:

=IF(COUNT(FIND("HW0",A1)),1,"")

--
Biff
Microsoft Excel MVP


"BRB" wrote in message
...
Hello,
I need to search for a string of characters in a cell and plave a "1" in
another cell if the string exists, such as:
If the string "HW0" appears I need to put a 1 in adjacent cell

A B
HW0233 1
hw0
apple

dog
HW03 1

I tried =find("HW0",A1,1), but if the cell is empty it returns #VALUE.

Help is appreciated.

Search for string of characters in a cell
 

Thank you... It worked well.

"T. Valko" wrote:

Try this:

=IF(COUNT(FIND("HW0",A1)),1,"")

--
Biff
Microsoft Excel MVP


"BRB" wrote in message
...
Hello,
I need to search for a string of characters in a cell and plave a "1" in
another cell if the string exists, such as:
If the string "HW0" appears I need to put a 1 in adjacent cell

A B
HW0233 1
hw0
apple

dog
HW03 1

I tried =find("HW0",A1,1), but if the cell is empty it returns #VALUE.

Help is appreciated.

Search for string of characters in a cell
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"BRB" wrote in message
...
Thank you... It worked well.

"T. Valko" wrote:

Try this:

=IF(COUNT(FIND("HW0",A1)),1,"")

--
Biff
Microsoft Excel MVP


"BRB" wrote in message
...
Hello,
I need to search for a string of characters in a cell and plave a "1"
in
another cell if the string exists, such as:
If the string "HW0" appears I need to put a 1 in adjacent cell

A B
HW0233 1
hw0
apple

dog
HW03 1

I tried =find("HW0",A1,1), but if the cell is empty it returns #VALUE.

Help is appreciated.