formula for separating parts of cells
One more...
Desred text for F13: Down
"Toppers" wrote:
.... 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?
|