"Confused" wrote:
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).