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