Change text string order

[Pretender]

I have a whole bunch of cells with text strings that look like this: 10-AXH-061

The text shown above should be changed into 10-061-AXH instead of 10-AXH-061.
Is there a formula to change the order of the text string?

 

[VoG]

Try

=LEFT(A1,3)&RIGHT(A1,3)&MID(A1,3,4)

 

[Pretender]

Thanks for the fast response, the formula solves the problem in most cases. There are some exceptions:
Sometimes the number is more complex like 07-RvdW-160 (4 digits in the middle) or RBO-10-MJR-139.

Any ideas?

 

[VoG]

For the RVDW example (and your earlier one) try

=LEFT(A1,3)&RIGHT(A1,3)&MID(A1,3,FIND("-",SUBSTITUTE(A1,"-","~",1))-FIND("-",A1))

With the possibility of multiple - it gets much more complicated. One way would be to use Data > Text to columns, delimited with - as the delimiter to split the codes across columns, then use a concatenate formula to reassemble the codes.

 

[Pretender]

Thanks for the tip! I had also considered text to columns, but Excel insists to turn "061" into "61" etc.