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

--

HTH

RP

"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