Hi.
I'm trying to extract a number formatted as text from within paranthesis.
The text is formatted like this:
"textexample (11-2222-33)"
I'm using the formula:
=SUBSTITUTE(MID(B1;FIND("(";B1)+1;255);")";"")
The output is "11-2222-33" as expected but some of the cells contains two paranthesis as following:
"textexample (aa) (11-2222-33)"
My formula outputs:
"aa (11-2222-33"
How can i modify the formula to take an extra pair of paranthesis in consideration and make the output the same as in the first example?
/Parre
I'm trying to extract a number formatted as text from within paranthesis.
The text is formatted like this:
"textexample (11-2222-33)"
I'm using the formula:
=SUBSTITUTE(MID(B1;FIND("(";B1)+1;255);")";"")
The output is "11-2222-33" as expected but some of the cells contains two paranthesis as following:
"textexample (aa) (11-2222-33)"
My formula outputs:
"aa (11-2222-33"
How can i modify the formula to take an extra pair of paranthesis in consideration and make the output the same as in the first example?
/Parre