If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
How to retrieve the value within string?
On Mon, 19 Apr 2010 22:09:29 -0400, "T. Valko" 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 |
|
Thread Tools | |
Display Modes | |
|
|