View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
confused confused is offline
external usenet poster
 
Posts: 193
Default Parsing data within parentheses

I have a set of data that I need to extract the number within the
parentheses. For example, I would like to extract the number 13.68% and
7.77% from the string below using a formula. Can someone help me?

532,251,450.39 (13.68%)
164,649,779.79 (7.77%)