One way:

=SUBSTITUTE(MID(A1,FIND("(",A1)+1,100),")","")

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
Does anyone have any suggestions on how to retrieve text within ()? for
example, Peter (A123) in cell A1, I would like to retrieve A123 into cell
B1.
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric