I have seen another post which is over my head and uses macros to solve a similar problem.

Here is my problem I need to to solve..

A1 contains text "12c 1b 3w" or "12c1b3w" or "1c12b3w" or "12 1" or "6c" or "12b" or "7" or can be blank. 1 to 3 sets of numbers, 1 or 2 digits each.

I would like cell B1 to extract(?) any set (or single) numbers and add them together!

I am using the below formula and It works fine to get the first set of numbers. But I can't figure out how to get the second or third set of numbers (and better yet add the two together)

=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$1000))))

Any help without macros? Thank you much in advance.