Need Formula for Adding Numbers with Words from the Same Cell

[TheAverageMan]

Hi there. I've been googling and haven't been able to find a working formula for this, and was hoping someone on here could help me with a formula that would combine all those numbers within cell H5, and place them into J5.

The numbers above J5 are all manually computed with a calculator and I just write it in there, but a formula would sure make it easier if they just grabbed all the numbers from the food cell and combined them.

I'm using Microsoft Excel 2010 also.

Thanks.

 

[TheAverageMan]

Okay, thanks a lot.

 

[hiker95]

TheAverageMan,

You are very welcome. Glad I could help.

And, come back anytime.

 

[István Hirsch]

Thanks Hirsch, I already changed my I2 to have calories in it, and the H2 also.

One thing to follow up on, I have this entire H column go for a couple hundred rows, does the macro work all the way till the end of the H column, or do I have to modify something if I reach a couple hundred days worth of calorie counting.

Thanks again.

You are welcome.

The macro question has been answered, do not hesitate to ask if there are questions about the formula.