That looks over complicated.

Just use a combination of IF, LEFT and RIGHT.

1356 is your value.

So for COL B you want

COLB = IF (LEN(B3) = 4, LEFT(B3,1), "")
COLC = IF (LEN(B3) >=3, LEFT(RIGHT(B3,3),1),"")
COLD = IF (LEN(B3) >=2, LEFT(RIGHT(B3,2),1),"")
COLE = IF (LEN(B3) >=1, RIGHT(B3,1),"")

Seems easy enough. My sytax might be slightly off but the logic should be right.

Adjust to where you want to put them.