I'd like to use a formula to sum the values found in text strings across multiple cells.
For example
Cell A1 = 18K,18Mo,18Co
Cell B1 = 2Na,2Si,2K,2Mg,2Fe,2Ca,2Al
I would like to have a formula in C1 that will return 68 (the sum of all the values in these two strings)
The text strings in each cell can be variable length and the numbers can be one, two or three digit numbers but will always be proceeded by a comma (except for the first occurance).
Any help would be greatly appreciated.
Thanks
Bookmarks