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