View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gmata Gmata is offline
external usenet poster
 
Posts: 41
Default How to separate Certain INFO from a Column

I have a bunch of products and i need to separate the brand of the products
For example:
Grey Flannel Cologne by Geoffrey Beene for Men
Lady Stetson Perfume by Coty for Women
Envy Cologne by Gucci for Men
Gucci Rush 2 Perfume by Gucci for Women
Coty Musk Cologne by Coty for Men
Tabu Perfume by Dana for Women
Canoe Cologne by Dana for Men

The brand is between by and for

Grey Flannel Cologne by "Geoffrey Beene" for Men

Thanks