How to select the value?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
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
 
In B1, B1 formatted as percentage:
=MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1)+0
 
Back
Top