try
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)


"Eric" wrote:

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