organize data

[martinez_pedro]

I have list of county roads and would like to organize them by odd number and pair.
Does any have a macro that can change the pair number first then the odd number here is an example

ORIGINAL LIST
COUNTY ROAD 32 & COUNTY ROAD 55
COUNTY ROAD 36 & COUNTY ROAD 55
COUNTY ROAD 51 & COUNTY ROAD 48
COUNTY ROAD 48 & COUNTY ROAD 35
COUNTY ROAD 31 & COUNTY ROAD 18
COUNTY ROAD 40 & COUNTY ROAD 49
COUNTY ROAD 43 & COUNTY ROAD 50
COUNTY ROAD 72 & COUNTY ROAD 29
COUNTY ROAD 27 & COUNTY ROAD 74

DESIRE RESULT
COUNTY ROAD 32 & COUNTY ROAD 55
COUNTY ROAD 36 & COUNTY ROAD 55
COUNTY ROAD 48 & COUNTY ROAD 51
COUNTY ROAD 48 & COUNTY ROAD 35
COUNTY ROAD 18 & COUNTY ROAD 31
COUNTY ROAD 40 & COUNTY ROAD 49
COUNTY ROAD 50 & COUNTY ROAD 43
COUNTY ROAD 72 & COUNTY ROAD 29
COUNTY ROAD 74 & COUNTY ROAD 27


IF ANYBODY CAN HELP THANK YOU VERY MUCH

[Sniper]

Good Day

is that description in one cell?

[Sniper]

Maybe This will work

[martinez_pedro]

Yes the description is in one cell

[Sniper]

Did you have a look at the attachment?