View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default formula for separating parts of cells

..... sorry ... remove % ...

E13:

=TRIM(MID($C$13,FIND("(",$C$13)+1,FIND(")",$C$13)-FIND("(",$C$13)-2))

"Jamie" wrote:

Current text in C13: Down 174.69 (1.25%)
Desired Text in D13: 174.69
Desired Text in E13: 1.25

What formulas can I put in D13 and E13 to get the desired text?