Search for string of characters in a cell

[BRB]

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.

 

[T. Valko]

Try this:

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

 

[BRB]

Thank you... It worked well.

Try this:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!