Reorder numbers from one cell into another cell (123456 to 341256

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generating vailid check digits 2
Check if cell value is between two numbers 3
Create if partial match then copy and paste data from one cell to another 1
Type 3 digits in one cell then automatically move to next cell. 4
cut and paste 5 numbers from one col to another for entire column 5
pulling data from another sheet 2
Replace letters with Plus Sign 3
Adding text to a cell from another cell 3

Top