How to select the value?

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
 
T

T. Valko

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
 
M

Max

In B1, B1 formatted as percentage:
=MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1)+0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve the value within string? 11
How to retrieve the value? 3
How to select the numbers? 1
How to set the value - 28 Nov? 1
How to retrieve the values within cells? 6
How to retrieve the sheet name? 2
How to determine the closed value? 7
How to retrieve text within ()? 13

Top