Originally Posted by
Everquest
I need to split a number into 4 different cells, depending on what the number is.
If the number 165,735 were entered, I would need the four cells to show:
Cell 1 = 1
Cell 2 = 6
Cell 3 = 57
Cell 4 = 35
In short, it takes 100 in Cell 4 to make 1 in Cell 3. 100 in Cell 3 would make 1 in cell 2, etc...
I have no idea how to go about doing this. Thanks for any help you can give.
I suppose you could use text to columns, this is just a recroded macro
if the value is always 6 digits then you could use something like this
=LEFT(A1,1)
=MID(A1,2,1)
=MID(A1,3,2)
=RIGHT(A1,2)
Bookmarks