=IF(OR(ISNUMBER(FIND("Target",A1)),ISNUMBER(FIND(" CVS",A1))),1,"")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dan Hale" wrote in message
...
I have a spreadsheet that I put Store names and addresses in the same cell
(say E5), I need a formula so that if E5 contains "Target" or "CVS" that
in
cell F6 it will return a number. Should be easy can someone please show me
the formula?

Thanks