troubleshooting Question

Substitute characters for certain parentheses in Excel formulas

Avatar of Steve_Brady
Steve_BradyFlag for United States of America asked on
Microsoft Excel
3 Comments2 Solutions347 ViewsLast Modified:
Hello,

Is there a way to use substitute characters for certain parentheses in Excel formulas?

As I'm sure anyone who writes many Excel formulas knows, keeping track of parentheses can sometimes be quite daunting.  Although Excel was kind enough to provide color codes (which help immensely) to keep things straight, I'm wondering if there is any way to also use other characters and somehow trick Excel into thinking they are parentheses.

I realize that several characters already have functions in formulas (e.g. $ and &).  But it seems like being able to use other characters which don't have a role could be helpful.  For example, suppose there was a way to enclose certain sections of a long formula with [square brackets] or {curly brackets}.* Even characters such as ^carets^ or #number signs# or |vertical bars (pipes)| seem like they could add a lot to keeping things straight.

That's probably kind of a crazy idea but I thought I would ask just in case.

Thanks

*I don't know if curly brackets need to be reserved only for array-saved formulas.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros