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!
Thank you I was making it a lot more complicated than I needed to!
No problem @Anweinbe! Please accept as solution if you can, thanks!