How to select the value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 19 Mar 2008 04:34 GMT

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

Reply to this Message

T. Valko - 19 Mar 2008 05:12 GMT

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

Signature

Biff
Microsoft Excel MVP

> Does anyone have any suggestions how to select the value?
> I would like to retrieve the value within (), such as
[quoted text clipped - 3 lines]
> Thank you very much
> Eric

Reply to this Message

Max - 19 Mar 2008 05:14 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Does anyone have any suggestions how to select the value?
> I would like to retrieve the value within (), such as
[quoted text clipped - 3 lines]
> Thank you very much
> Eric

Reply to this Message