How to retrieve the value within string?
in [General]
|
From: Eric on 19 Apr 2010 06:29 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
From: Mike H on 19 Apr 2010 06:49 Eric, Try this which assumes it's the first set of parenthesis in the cell =MID(A1,FIND("(",A1)+1,FIND(")",A1,FIND("(",A1))-FIND("(",A1)-2)/100 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "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
From: Mike H on 19 Apr 2010 06:51 forgot to mention.format as a percentage -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mike H" wrote: > Eric, > > Try this which assumes it's the first set of parenthesis in the cell > > =MID(A1,FIND("(",A1)+1,FIND(")",A1,FIND("(",A1))-FIND("(",A1)-2)/100 > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "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
From: Jacob Skaria on 19 Apr 2010 07:21 Another way will handle .......(3.25%) ------(3.25%).............. 'As text =REPLACE(MID(A1,FIND("(",A1)+1,255),FIND(")",MID(A1, FIND("(",A1)+1,255)),255,"") 'As percentage (format the cell) =--REPLACE(MID(A1,FIND("(",A1)+1,255),FIND(")",MID(A1, FIND("(",A1)+1,255)),255,"") -- Jacob (MVP - Excel) "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
From: Ron Rosenfeld on 19 Apr 2010 07:43
On Mon, 19 Apr 2010 03:29:01 -0700, Eric <Eric(a)discussions.microsoft.com> 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 enclosure: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) --ron |