Link to home
Start Free TrialLog in
Avatar of Steve_Brady
Steve_BradyFlag 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.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve_Brady

ASKER

Thanks guys.