Place individual digits from a number into seperate cells

your file shows a different result to

For example the number 123 I need 1 to be in cell b1, 2 to be in c1, and 3 to be in cell d1.

you can use
=MID($A2,COLUMN()-(COLUMN($B2)- 1),1)
which will turn each number into text
If you want to retain the numbers then

=IFERROR(MID($A2,COLUMN()-(COLUMN($B2)- 1),1)*1,"")

BUT i dont know how to work out which is the longest number in the list and then base that on the columns to fill - so if you have a 10 number in the list
and say a 1 in a cell to split - it will goto the 10th column and line up

I suspect there maybe something in 365 that you could do - clever for this - and other members should answer

BUT as i say the text in the question is different to the solution example shown on spreadsheet

Please try in B2 and copy down:

Formula:

Please Login or Register  to view this content.

as i mentioned , a member will be able to provide a solution , i was overthinking it as i was assuming various numbers of different length might be added to list and so if the number is for example added to the list 1234554321 - then you would want to change ALL the splits to start in the 10th columns away

based on the last supplied formula
maybe then
=SORTBY(IFERROR(--MID(A2,SEQUENCE(,MAX(LEN($A$2:$A$100)),LEN(A2),-1),1),""),SEQUENCE(,MAX(LEN($A$2:$A$100))),-1)