Removing commas from the brackets in file

Hello,

I need to separate it into columns, I want to use commas as delimiters, BUT there are commas between brackets that are ruining it all.
EXAMPLE: MERCEDES-BENZ SPRINTER 3-t Platform/Chassis (B910, B907) (18-0),
So the comma after (18-0) is what I would use as delimiter. The comma in (B910, B907) is the comma that ruins everything.
I been checking this forum thread from 2008 "Remove commas if they are between brackets" (I cannot post links yet), which is quite similar to my problem, I tried to use the VBA that was created for it (the macro formula I think it is) but I cannot launch it, maybe it changed through the time since im using 2021 excel or I dont know what im doing wrong, but it does not work for me.

So maybe I could have it explained first how to use that vba thingy properly that is provided there cuz searched the internet, tried many things and still no clue what i am doing wrong. I am really unexperienced with macros coding (if it is called like that) and I have no clue why it is not working. I tried, googled, but I just cant get it what im doing wrong.

To show the problem I am attaching excel worksheet which has few examples, first one I made manually to show how it should be and then next ones are examples which represent how complexed some strings are.
Thanks.

try Power Query

Please Login or Register  to view this content.

Expected results are described, its just no commas between brackets, thats all I need so other examples were not filled on purpose to leave space for tryouts, I am quite new in the forums so I might have understood it wrong, sorry for that.

try this

Please Login or Register  to view this content.

I am not sure how it works, how to do it, but it served the purpose, thank you so much <3

yes, they should. Everything that is between brackets.

Originally Posted by Softas

Expected results are described, its just no commas between brackets, thats all I need so other examples were not filled on purpose to leave space for tryouts, I am quite new in the forums so I might have understood it wrong, sorry for that.

Expected results are described, its just no commas between brackets, thats all I need so other examples were not filled on purpose to leave space for tryouts, I am quite new in the forums so I might have understood it wrong, sorry for that.

Originally Posted by Softas

I am not sure how it works, how to do it, but it served the purpose, thank you so much <3

you can learn more from here: https://learn.microsoft.com/en-us/power-query/

Originally Posted by Glenn Kennedy

If:

1. You are using a PC, not a Mac,

2. Your version has TEXTJOIN (it should have...),

3. This should work, but may require entry as an array formula:

=LET(r,IFERROR(FILTERXML("<A><B>"&SUBSTITUTE(SUBSTITUTE(A2,"(","</B><B>("),")",")</B><B>")&"</B></A>","//B"),""),TEXTJOIN(" ",,IF(LEFT(r,1)="(",SUBSTITUTE(r,",",""),r)))

This is next level stuff, thank you, it helped, it removed all unnecessary commas. Even the ones that were unnecessary and were not between brackets. Brilliant.

Originally Posted by Glenn Kennedy

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Thank you, added the reputations and will make it solved, have a nice day!