Parsing data within parentheses

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

I have a set of data that I need to extract the number within the
parentheses. For example, I would like to extract the number 13.68% and
7.77% from the string below using a formula. Can someone help me?

532,251,450.39 (13.68%)
164,649,779.79 (7.77%)
 
Assuming (as your examples show) that the number in parentheses is
**always** at the end of the text and those are the **only** parentheses in
the text...

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"(",REPT(" ",99)),99)),")","")
 
Confused said:
I have a set of data that I need to extract the number within the
parentheses. For example, I would like to extract the number
13.68% and 7.77% from the string below using a formula. [....]
532,251,450.39 (13.68%)
164,649,779.79 (7.77%)
Click to expand...

=--MID(LEFT(A1, LEN(A1)-1), 1+FIND("(",A1), 99)

That assumes you want a numeric result. Omit "--" if you want text.

Also, that assumes that the right parenthesis is the last character, as it
is in your examples.

Finally, 99 at the end is just an arbitrary large number. Choose a larger
one if necessary, or replace it with LEN(A1).
 
Back
Top