Try one of these:

If the number inside the ( ) is *always* positive:

=-MID(A1,FIND("(",A1),100)

Or, this generic version:

=--MID(SUBSTITUTE(A1,")",""),FIND("(",A1)+1,100)

Format as PERCENTAGE


--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
Does anyone have any suggestions how to select the value?
I would like to retrieve the value within (), such as
2.532 (2.7%) in cell A1
It should return 2.7% in cell B1.
Does anyone have any suggestions?
Thank you very much
Eric