My cells contain such data as this:

Cell 1 Cell 2
1a2b4c8d1e13f 1a4b3c2d4e5f

i.e. its a manual formula: 1 of a, 2 of b, 8 of d

I need to add up how many of a, how many of b, how many of c etc. to produce a total.

i.e. above there are 8 d's, and 2 d's, = 10 d's in total.

Can anyone help me with a formula to do this? I tried the MID function but it didn't work for the random cells that had two digits before some of the letters(e.g. 13f)


Thankful for ANY help


Chris