So here's my way of thinking about this....I would eventually use 'Convert text to column wizzard' ~ Delimited: "Other = 0" and check the box 'Treat consecutive delimiters as one [ this is in the Ribbon, under DATA / Text to Columns. Before that I have a Function in VBA that reverses the string. Once the string is reversed, I use the Text to column wizzard to separate the numbers by the character '0' (which will put the single character or cluster of numbers into their own cells...then it's just a matter of concatenating them together. Reverse is available in vba code...the function is ~
I've attached sheet too....hope this helps.