Macro that gets rid of brackets in formula as in the example.

[cezar1984]

Hello,

First time here, as I can't find the answer I'm looking for browsing the internet.

Is there a way of writing a macro in excel that does this ?

How do I get from this: (A/B/C)+(D/E)
To this: A+D or A+E or B+D or B+E or C+D or C+E

This is just an example, the macro I want to write is to basically get rid of the brackets and make the combinations based on order of operations and algebra, if that makes any sense.

Example 2:

Before: ((A/B)+C))+(D/E)
After: A+C+D or A+C+E or B+C+D or B+C+E

I don't need the final result, A B C D E are not numbers, they are options, I only need the longer version of the formula without the brackets.

Example from what I need to do (manually without macro):
I have option in this format with brackets:
((EN-YV/EN-XW/EN-XX)+(DGADD/DGAEG/DGAA8))/((EN-XW/EN-XX)+DGAC4)
Eliminating the brackets, this becomes:
DGAA8_PLUS_EN_XW or DGAA8_PLUS_EN_XX or DGAA8_PLUS_EN_YV or DGAC4_PLUS_EN_XW or DGAC4_PLUS_EN_XX or DGADD_PLUS_EN_XW or DGADD_PLUS_EN_XX or DGADD_PLUS_EN_YV or DGAEG_PLUS_EN_XW or DGAEG_PLUS_EN_XX or DGAEG_PLUS_EN_YV

Please help if it's possible.

Thank you.
Cezar