formula for separating parts of cells
In Cell B1: =FIND(" ",C13,1) find the first blank in your string
In Cell C1: =FIND(" ",C13,B1+1) find the next blank
In Cell D13: =VALUE(MID(C13,B1+1,C1-B1-1)) extract between the two blanks
In Cell E1: =FIND("(",C13)
In Cell F1: =FIND(")",C13)
In Cell E13: =VALUE(MID(C13,E1+1,F1-E1-1))
If you want to avoid the intermediate cells, feel free to replace their
value with formulas in D13 and E13, something like:
D13: = =VALUE(MID(C13,FIND(" ",C13,1)+1,FIND(" ",C13,FIND("
",C13,1)+1)-FIND(" ",C13,1)-1)), but it is hardly undersandable and make
sheet maintenance more difficult, in my humble opinion.
Stephane.
"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?
|