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
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"hyyfte" wrote in message
...

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?


--
hyyfte
------------------------------------------------------------------------
hyyfte's Profile:
http://www.excelforum.com/member.php...o&userid=13187
View this thread: http://www.excelforum.com/showthread...hreadid=265470