easy problem, mirror information in cells, need help!

[raptor20561]

i have a list of data as the following


9910/1758
9910/1757
9910/1756
9910/1755


id like to make it so that the last 4 digits come first, in essence "mirroring" it. moving the last 4 digits to the front and the front 4 to the last...

1758/9910
1757/9910
1756/9910
1755/9910

the 9910 changes in my list, so it is not a fixed number! it goes from 0002 to 9910, but it the cells always stays in the form "4 numbers / 4 numbers"

if this makes no sense just reply and ill try to make it more clear with more examples

[mudraker]

In a empty cell enter formula

Change formula reference from A1 to your column and cell

=RIGHT(A1,4)&"/"&LEFT(A1,4)

Copy formula down column as required.


If required you can also copy column and pastespecial values to get rid of formula and leave only values

[raptor20561]

yay thanks alot! saved A LOT of work for me heh, im starting to understand how excel programming works