Thanks Guys.....does exactly what I wanted.

Cheers
GK
"Tom Ogilvy" wrote in message
...
Left of a double quote:
=if(counif(B1,"*apple*")0,"apple","")

--
Regards,
Tom Ogilvy