Thanks Peo
Worked Great!!!!
But in addition to "My Text String (MTS)" I also found
"My Text String (ADT (MTS)"
For which I would still like to return "MTS"

"Peo Sjoblom" wrote:

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