Forum Discussion
Solved
EXTRACT NUMBER WITH FORMULA
Hi everyone, can someone help me solve this issue? If in a cell there is this term "DISCOUNT 15.00%" how can I extract only the number within text, so I can use it as source amount for calculatio...
Hi,
Try
=VALUE(MID(B93,FIND(" ",B93)+1,FIND("%",B93)-(FIND(" ",B93)+1)))
It worked for me. I added "Value" just to get a number instead of a text.
Best regards
Per
=TEXTAFTER(TEXTBEFORE(D5;"%");" ") where the string "DISCOUNT 15.00%" is in D5.
- To prevent calculation errors, it's advisable to wrap this formula with VALUE()
- Right. By applying the formula, without finish it, it prompt me to check the formula.
