Steve_Brady

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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER