Does anyone know a way to split 12 digit number into separate digits starting from 0 using Excel.
Example :012345678901 is split as 0,1,2,3,4,5,6,...
I've use this formula
=MID($A1,column()-1,1) but it is unable to read the 1st digit 0. It keeps appearing as 1,2,3,4,5,... instead of 0,1,2,3,4,5,... and also if there is a number starting with 00.
Is there any formula that its able to read 0 or 00 as the first number followed by the rest?