| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering 16 digit numbers - last digit turns to zero | New Users to Excel | |||
| Split 5 digit number into 5 cells | Excel Discussion (Misc queries) | |||
| Need to split a 17 digit number into 17 cells by paste function. | Excel Discussion (Misc queries) | |||
| what is the minimum numbers set for 4 digit numbers from 0000 to 9 | Excel Discussion (Misc queries) | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
![hyyfte[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
