Thread: Text fomula
View Single Post
  #5   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

Left of a double quote:
=if(counif(B1,"*apple*")0,"apple","")

--
Regards,
Tom Ogilvy