Parsing data within parentheses

[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%)

 

[Rick Rothstein]

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)),")","")

 

[Ashish Mathur]

Hi,

Try this

=mid(A2,search("(",A2,1)+1,search(")",A2,1)-search("(",A2,1)-1)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Joe User]

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%)

=--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).