Thread: Contains function help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OJ[_2_] OJ[_2_] is offline
external usenet poster
  
Posts: 111
Default Contains function help
Try this...

=IF(ISERROR(SEARCH("(oc:",B1,1)),B1,LEFT*(B1,SEARC H("(oc",B1,1)-2))

HTH,
OJ

Reply With QuoteReply With Quote