Below is an example of a CSV output I receive from a website where I sell my products:
2010-05-28 12:26:53,36714734,””,””,0,0,0,”MiLOS DBO Sneakers – White – Female”,”Graceleigh Broderie”,”Graceleigh Broderie”,199,10
I am interested in a formula that can extract “MiLOS DBO Sneakers – White – Female” from the above string. In addition, if it possible to also extract the “199” and “10” in separate columns.
I would be very appreciative if someone could help me.
Apologies, I’m importing the data into Microsoft Excel.
Kind Regards
Jonathan Heavens
