Hi all,
I'm trying to invert two columns if one starts with a certain text, in this case "acc-"
As you can see, sometimes the column A has the "acc-", while the brand name is in column B and sometimes it's the opposite. I want to put all the brands in column B and the "acc-" in column A.
I've already tried something with Left(), but the IF THEN is way beyond my skill level. Does anybody have an idea ?
Thanks in advance
image.png
Bookmarks