Hi everyone, appreciate if anyone can help me to create a formula to extract numbers and operators from a cell containing combination of texts, numbers and operators in random sequence.
sample value in cell say =100days* (3hrs+0.050weeks)/4
target result =100*(3+0.050)/4
Appreciate everyone's idea if there can be a formula to solve my query above.
Thanks heaps in advance.
sample value in cell say =100days* (3hrs+0.050weeks)/4
target result =100*(3+0.050)/4
Appreciate everyone's idea if there can be a formula to solve my query above.
Thanks heaps in advance.