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.

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.