Thread: refer a cell text in b1 and extract remaing text from a1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narnimar Narnimar is offline
external usenet poster
  
Posts: 132
Default refer a cell text in b1 and extract remaing text from a1
I got text in a1 like "Hydro carbon resin Petrolac 120" and in b1 like
"Petrolac 120". Now I need in c1 as "Hydro carbon resin". A formula needed to
extract the list in a with reference to list in b in c column.
Reply With QuoteReply With Quote