Parsing Help

[Anweinbe]

Hi all,

I am having an issue with parse, probably just due to my inexperience. I have one column I would like split into 2, but also dropping the "x" Some of my quantities are 1, other are 50, etc. 

What I have: "1× Liquid (677) - 50MG/ML"

What I want:

Column 1: "1"

Column 2: "Liquid (677)...."

Essentially just removing the "x " and splitting. Please note it is not a normal letter x. The actual character is in the "what I have" box. 

Thank you so much!

[Bren_Spill2]

Hi @Anweinbe - see screen shot below. 

 

[Anweinbe]

Thank you I was making it a lot more complicated than I needed to!

[Bren_Spill2]

No problem @Anweinbe! Please accept as solution if you can, thanks!