Quick query for you...

Is it possible to sum the numbers in a cell which would have the following content?

12ml, 324sl, 1hl, 34gc

The numbers could very in length but there will always be 2 letters and each element in the cell would always be seperated by a comma. The number of elements in the cell could vary from anything from a cell containing nothing to a cell containing easily more than a dozen elements.

The sum of the number above would be 12+324+1+34 etc...

I don't believe there is a function in XL to do the above (could be wrong) so was thinking I might have to go the route of using macros.

What do you think?...Cheers...Alkemist