Rearrange digits within a cell

[Gene31705]

I have several thousand "locations" that I need to modify. An example of a location is M110285AA. I need to change several digits to the location digits due to restructuring. The following is an example of current and desired.

CURRENT - DESIRED
M118502AA - M110285AA
A138612AA - A311286AA

Thanks for any help.

 

[XOR LX]

Hi.

Forgive me for not seeing it, but what precisely is the logic that determines the new order of characters in each case?

Regards

 

[Gene31705]

The first letter is the warehouse. The next number is the bay, the next is the floor, the next TWO are the row and the last TWO digits are the isle. The AA is the level of pallets - AA bottom (ground), BA one above AA, CA two above AA (ground), etc. My biggest problems are the forty through the seventh digit. I need to swap these four digits (or these two sets of digits). Second, I need to swap the first two numbers like 13 to 31, etc.

I hope this clears it up. Thanks

 

[Rick Rothstein]

My biggest problems are the forty through the seventh digit. I need to swap these four digits (or these two sets of digits). Second, I need to swap the first two numbers like 13 to 31, etc.

Give this formula a try...

=LEFT(A1)&MID(A1,3,1)&MID(A1,2,1)&MID(A1,6,2)&MID(A1,4,2)&RIGHT(A1,2)

 

[Gene31705]

Rick,

Unbelievable. You are my hero. I guess swapping the first two numbers (like 13 to 31 - after the warehouse letter) is just as simple - if you know what you're doing. Remember the locations A138612AA

Thanks a lot, you have saved me a lot of work.

 

[Gene31705]

Rick,

Sorry, I didn't look at the every end. It is all done. Thanks very much.