Four digit numbers need to be split up

[hyyfte]

I have the number 2537 in cell A1.


I want:
2 in A2
5 in A3
3 in A4
7 in A5


Can anyone help with this

 

[Bob Phillips]

=--mid(A1,1,1)
=--MID(A1,2,1)
=--MJID(A1,3,1)
=--MID(A1,4,1)

 

[Max]

Try in A2:

=IF(LEN($A$1)>=ROW(A1),MID($A$1,ROW(A1),1)+0,"")

Copy A2 down until blanks "" appear,
signalling exhaustion of digits in A1