Forum Discussion

Tse-Wei Chen's avatar
Tse-Wei Chen
Copper Contributor
Aug 09, 2018

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 ...
excel
Formulas and Functions
  • Tse-Wei Chen's avatar
    Tse-Wei Chen
    Copper Contributor
    Aug 14, 2018
    Sorry for the late reply I was in the project site.
    This is exactly what I need!!!
    It's awesome.
    Did you create a "sumr" function to grab the data?
    This function wasn't built in excel

    Thanks
    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Aug 14, 2018

      Mr. Chen

      Actually, it is outside of my 'powers'..

      I sought help somewhere and some helpful people pitched in.

      I properly attributed their work in the sub modules.

      I am glad it helped you.

       

      • Tse-Wei Chen's avatar
        Tse-Wei Chen
        Copper Contributor
        Aug 17, 2018
        That's a really great solution.

        Thanks again.

Resources