How to retrieve the value within string?
Yes, that's how I interpreted this:
There is a string in cell A1, such as
........ .... (3.25%)
--
Biff
Microsoft Excel MVP
"Ron Rosenfeld" wrote in message
...
On Mon, 19 Apr 2010 18:28:24 -0400, "T. Valko"
wrote:
Here's another one...
=--SUBSTITUTE(MID(A1,FIND("(",A1)+1,10),")","")
Format as Percentage
I believe that requires that the ")" is the last non-space character
--ron
|