word search

[Pivotrend]

sup pros


i have in Cell A1:"Mortgage Investment"
i want cell B1 to show number 1 if Cell A1 contains the word "Invest" &
to show 0 if not

 

[Don Guillett]

Have a look in the help index for FIND