How to retrieve the value within string?
Note that it needs to be double unary MINUS. Double unary PLUS wouldn't
work.
--
David Biddulph
"Ron Rosenfeld" wrote in message
...
On Mon, 19 Apr 2010 07:43:38 -0400, Ron Rosenfeld
wrote:
On Mon, 19 Apr 2010 03:29:01 -0700, Eric
wrote:
There is a string in cell A1, such as
........ .... (3.25%)
I would like to retrieve the text inside (), which should return 3.25% in
cell B1.
Does anyone have any suggestions on how to retrieve the text within
string?
Thanks in advance for any suggestions
Eric
Assuming no parenthesis prior to the desired enclosu
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
--ron
OH, and if you want to convert the text to a value, as the other
respondents
seem to be assuming, you can merely precede the above with a double unary:
=--MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
--ron
|