IF statements based on text in a string

[giantwolf]

Hi,

I want to return Y or N for each row where a certain word (lets say "Apple") appears anywhere in the reference cell. Therefore in the below example the first 3 rows contain apple (somewhere in that cell) so Y is returned. I can get it to work when apple isd the only thing in the cell but not if it appears with text before and/or after it.

ie:

A B

apple Y
apple orange Y
orange apple Y
pear N
grape N


Many thanks.

GW