• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Removing extra parentheses in Excel

Bird222

Diamond Member
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.
 
Last edited by a moderator:
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?
 
I don't know how that could be done without writing code. I would not mess with long formulas that are working as intended.
 
Do yourself a big favor and move long formulas to user defined functions (VBA). Makes them so much easier to read/check.
 
Back
Top