Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reorder numbers from one cell into another cell (123456 to 341256
I need to take the numbers in one cell and change their order in another cell.
For Example E8= 778899 I want cell A8 to show the numbers like so 887799. Basically a terminal digit format for medical records. For those who don't know, they group numbers together based on their system. In this example thier terminal digit is broken down as such, position 1 = digits 3&4 Position 2 = digits 1&2 Position 3 = digits 5&6. Its weird, but I can't find any help anywhere online. Please either direct me to somewhere online or let me know how I can accomplish this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reorder numbers from one cell into another cell (123456 to 341256
=MID(E8,3,2) & LEFT(E8,2) & RIGHT(E8,2)
-- Gary's Student "pimpy4" wrote: I need to take the numbers in one cell and change their order in another cell. For Example E8= 778899 I want cell A8 to show the numbers like so 887799. Basically a terminal digit format for medical records. For those who don't know, they group numbers together based on their system. In this example thier terminal digit is broken down as such, position 1 = digits 3&4 Position 2 = digits 1&2 Position 3 = digits 5&6. Its weird, but I can't find any help anywhere online. Please either direct me to somewhere online or let me know how I can accomplish this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do u reorder data in a column so last cell entry is first? | Excel Discussion (Misc queries) | |||
HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL? | Excel Worksheet Functions | |||
Changing 123456 to $1234.56 | Excel Worksheet Functions | |||
Columns went from ABCDEF to 123456. How do I fix? | Excel Discussion (Misc queries) | |||
How can I reorder a CELL alphabetically in Excel | Excel Discussion (Misc queries) |