How do I move characters within a string? Or how do I recognize them?

[111StepsAhead]

If I have a cell with a string, like 123AB, is there a way I can use a macro to move the letters to the front of the string?

Please Login or Register  to view this content.

So does anyone know how to do this? The format is generally the same but could slightly vary.

123AB
123A
12AB
1AB
etc.

But the end result does the same thing to each value.

AB123
A123
AB12
AB1
etc.

I appreciate your guys help.

[arthurbr]

Is a formula solution ok? ( see attached)

[Domski]

Or VBA:

Please Login or Register  to view this content.

Dom

[111StepsAhead]

This was the final solution. Thanks Domski for your time.

Please Login or Register  to view this content.

[StephenR]

Another approach:

Please Login or Register  to view this content.