View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
confused confused is offline
external usenet poster
 
Posts: 193
Default Extracting certain text

I have a list of text in each cell where I have to extract the #% after the
"Y-"
Here is an example, the string is Y-24.47% P-24.37%. I need to extract 24.47%
Is there a formula for this?

Any help is much appreciated.

Thanks.