Can any one please help......l've paste the form guide but can not separate the 4 placings ...eg l have the placing of 1356 in Col.B ..R3 would like to put 6 in Col.C R3..5 in E..3 in F...1 in G.... l've tried this formula but only goes to 3 ...numbers.....=IF(LEN($B3)=2,"",IF(LEN($B3)=1,"",LEFT($B3,1)))....=IF(LEN($B3)=1,"",IF(LEN($B3)=3,MID($B3,2,1),LEFT($B3,1)))
=RIGHT($B3,1)..Thanking you Blkscout

anything in column d ?

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.

b3= 1356
c3= =MID(B3,LEN(B3),1)
d3= =MID(B3,LEN(B3)-1,1)
e3= =MID(B3,LEN(B3)-2,1)
f3= =MID(B3,LEN(B3)-3,1)


is that whatyou mean

even tidier:

b3= 1356
c3= =iferror(MID(B3,LEN(B3),1),"") etc

d3= =MID(B3,LEN(B3)-1,1)
e3= =MID(B3,LEN(B3)-2,1)
f3= =MID(B3,LEN(B3)-3,1)