Rearange order of numbers from one cell to another cell

[yenom2]

We have a series of numbers, which are several characters long. We want to change the first two numbers, to the 5th and 6th position, and the ones in the 5th and and 6th position to move to the 1st and 2nd position.

Ex.
282114778600220 convert to 142128778600220

We have a column of these in our spreadsheet that we'd like to change. Is this possible?


Here is attached spreadsheet, Column N is where the subject numbers are. and Column C is where I'd like the new rearranged numbers to be output.

Thanks in Advance for your help.

[ChemistB]

In N2 dragged down

=REPLACE(REPLACE(N2,1,2,MID(N2,5,2)),5,2,MID(N2,1,2))

Then you can copy > paste special > Values back into N if you want.

Does that work for you?

[Kiran_555]

Hi,

Put this formula in C2 cells and hit enter. And then you drag this formula to the entire column as required.


=MID(N2, 5, 2) & MID(N2, 3, 2)&MID(N2, 1, 2)& MID(N2, 7, LEN(N2)-6)

Regards,
KK

[yenom2]

thanks for the quick help!