Removing extra parentheses in Excel

[Bird222]

Is there a way to have excel check a formula to see if there are extra/unneeded parentheses in it? I've got some pretty long formulas that I'm sure have unneeded parentheses in them.

 

[OverVolt]

I like extra parentheses.

You could write a script to do it but I wouldn't really trust anything of importance to a script written in a short time without alot of testing soo....

Just be happy the formulas are already completed?

 

[kranky]

I don't know how that could be done without writing code. I would not mess with long formulas that are working as intended.

 

[sdifox]

how is excel going to determine that?

 

[Possessed Freak]

You are forcing order of operations with the parenthesis. I would not want any automated script removing them.

 

[pgipgi666]

use online syntax checker

 

[pgipgi666]

depends on which language is being used

 

[Zorba]

Do yourself a big favor and move long formulas to user defined functions (VBA). Makes them so much easier to read/check.