Verify all parenthesis are closed

[icyrius]

I have a column in Excel with formulas written as text. For example, "Product A = (B + (C - D))" all as text.

I noticed some of these formulas do not have all their parenthesis closed. For Example, "Product A = (B + (C - D)" as text.

Is there a way to check that for every open parenthesis "(" there is a closed parenthesis ")"

I just cannot think of a way to approach this.

Thanks.

[Pete_UK]

You can use this formula in B1:

=LEN(A1)-LEN(SUBSTITUTE(A1,"(",""))

to tell you how many open brackets you have. A similar formula in C1:

=LEN(A1)-LEN(SUBSTITUTE(A1,")",""))

can tell you how many closed brackets you have.

Hope this helps.

Pete

[icyrius]

Pete,

This is great.

Once I determine the total missing parenthesis, how can I identify the spot to insert the missing parenthesis?

Thanks.

[Pete_UK]

For that you would need a full syntax checker - that's a bit beyond the scope of a formula !!

Pete