split cell contents

Originally Posted by rwgrietveld

Assume
A2 = A05B
B1, C1, D1 are 1, 1, 2

The B2 would be =MID($A$2,1+SUM($B$1:B$1)-B$1,B$1)

Drag right and down (If there is more then A2)

Excellent, thanks rwgrietveld !!