View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
m m is offline
external usenet poster
 
Posts: 64
Default Extract text within ( )

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