Split a number from one cell to separate cells for each
T: That worked, sort of. What if the number I am using starts with a 0?
--
Rob
"T. Valko" wrote:
Ok...
A1 = 12345
Enter this formula in A2 and copy down until you get blanks:
=IF(ROWS(A$2:A2)<=LEN(A$1),--MID(A$1,ROWS(A$2:A2),1),"")
--
Biff
Microsoft Excel MVP
"Rob" wrote in message
...
That was what I tried intially, but I got the following:
12345
1
12
123
1234
12345
I want the following results:
12345
1
2
3
4
5
Does this explain what I am looking for a little better?
--
Rob
"T. Valko" wrote:
Try this:
A1 = 12345
Enter this formula in B1 and copy across until you get blanks:
=IF(COLUMNS($B1:B1)<=LEN($A1),--MID($A1,COLUMNS($B1:B1),1),"")
--
Biff
Microsoft Excel MVP
"Rob" wrote in message
...
I want to enter a number in one cell and then in different cells have
each
number appear. For example, I type 12345 in one cell and then have 1
in a
cell, 2 in a cell, 3 in a cell, 4 in a cell, and 5 in a cell. Is there
a
formula to do this?
--
Rob
|