Any chance you could explain what you did to me?

Also, I've just checked and the codes actually start with a number (which is irrelevant at this point) and instead, the number of a's, b's is indicated by the number after the letter.

i.e. 2a3b8c2d18e3f9g8k13

Can you help me change the formulas to get the same result?

and what if the data is shorter than others. e.g. just 2a3b8c2d18e
i keep getting VALUE error in the cell.


Thx

Chris