How to select the value?
 

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

How to select the value?
 

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

How to select the value?
 

In B1, B1 formatted as percentage:
=MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1)+0
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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