Are those the only parenthesis?

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

replace A1 with your cell



--


Regards,


Peo Sjoblom

"M" wrote in message
...
Formula to enter to extract the text within ( ) in a text string
Example: "My Text String (MTS)" and extract or return MTS
Currently the "(XXX)" is always at the end of the text string
Using MS Excel 2002