Thread: Contains Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Contains Function
Use Find instead.

FIND("Text to Find", "Text to Search", Start Position)

=if(ISERROR(FIND("Golf",A1,1),"","*")
--
Kevin Backmann
Reply With QuoteReply With Quote