Hi Everyone,
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
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