Four digit numbers need to be split up
 

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

--
hyyft
-----------------------------------------------------------------------
hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318
View this thread: http://www.excelforum.com/showthread.php?threadid=26547

Four digit numbers need to be split up
 

=--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

Four digit numbers need to be split up
 

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