Avatar of Steve_Brady
Steve_Brady
Flag for United States of America asked on

Substitute characters for certain parentheses in Excel formulas

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.
Microsoft Excel

Avatar of undefined
Last Comment
Steve_Brady

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
dlmille

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Steve_Brady

ASKER
Thanks guys.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck