Remove commas if they are between brackets

Hi there

Does anyone know a quick formula that allows one to remove all of the commas from a cell if they are between brackets, so (01, 02) becomes (01 02), but text in the same cell that may also include commas are not affected:

Peanuts, Pizza, Pies (01, 02, 04) = Peanuts, Pizza, Pies (01 02 04)

Thanks in advance

Luke

unfortunately not necessarily, the cells have quite a lot of data in them and all are formatted slightly differently

Hi XOR LX,

there could be two (or perhaps more) instances like the example you have provides

All the best

Luke

Hi, with only one set of brackets, maybe (with text in A1):
=IFERROR(LEFT(A1,SEARCH("(",A1)-1)&SUBSTITUTE(MID(A1,SEARCH("(",A1),SEARCH(")",A1)-SEARCH("(",A1)+1),",","")&MID(A1,SEARCH(")",A1)+1,100),A1)

Thanks for trying to help. I just can't think of how to do this, maybe a macro is needed. The reason that I am trying to do this is because I was to delimit the cell by a comma, but sometimes commas are within brackets, so I just need these to be replaced! Sounds so simple but seems more difficult than I anticipated, I look forward to hearing anyone else's help :-)

thanks so much, seems to work a treat

Have a great one

great, thanks Hawkeye16, I'll put it into action :-)

Hi

I'm glad your problem is solved. This udf would be another option.

Assuming the opening and closing brackets always come nicely in pairs, like in the examples:

Please Login or Register  to view this content.