| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve the value within string?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve certain char within a string? | Excel Discussion (Misc queries) | |||
| How to retrieve certain text from string? | Excel Discussion (Misc queries) | |||
| How to retrieve certain text from string? | Excel Worksheet Functions | |||
| How to retrieve character from a string for excel? | Excel Discussion (Misc queries) | |||
| How do I retrieve the text string from the right of a cell | Excel Worksheet Functions | |||
Threaded Mode
