Prev: IFBLANK
Next: can quadratic equations be solved in excel
From: T. Valko on 19 Apr 2010 22:09
Yes, that's how I interpreted this:

>There is a string in cell A1, such as
>........ .... (3.25%)

--
Biff
Microsoft Excel MVP


"Ron Rosenfeld" <ronrosenfeld(a)nospam.org> wrote in message
news:kg0qs5dmjl3gijpulibfk68f101do6skjq(a)4ax.com...
> On Mon, 19 Apr 2010 18:28:24 -0400, "T. Valko" <biffinpitt(a)comcast.net>
> 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


From: Ron Rosenfeld on 20 Apr 2010 07:47
On Mon, 19 Apr 2010 22:09:29 -0400, "T. Valko" <biffinpitt(a)comcast.net> wrote:

>Yes, that's how I interpreted this:
>
>>There is a string in cell A1, such as
>>........ .... (3.25%)
>

I agree that is consistent with his example, although his textual description
allows for characters after, but does not definitely indicate there could be.

--ron
First  |  Prev  | 
Pages: 1 2 3
Prev: IFBLANK
Next: can quadratic equations be solved in excel