sorting in a cell
I have a very long list which I would like to sort (see first column example)
first by the last two digits and then the 3rd digit, so that the sorted list
would appear like column 2. I don't know where to start on this.
2297814 2179312
766961 2297814
2200735 2317528
2113780 2005233
2225041 2200735
604875 2225041
2103953 557042
557042 2272153
738066 2103953
2179312 766961
2272153 738066
2224766 2224766
2317528 604875
2126879 2126879
2005233 2113780
2260982 2260982
|