Forum Discussion
How to sum the numbers in a text string?
Hi If I have a text string in a cell below: "Path 8.5+Metrocard 10" And I would like to return the result of the sum of the numbers 8.5+10 "18.5" (see attached image) How can I do that by using ...
Mr. Chen
attached herewith is the sample again for you to test - this time it had a direct formula - no need for Name Manager.
Hope this is what you needed.
thank you