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
|