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.