sorting codes
Posted by Gokhan Caglayan on September 27, 2001 11:12 PM
I have codes like
10F1,10F30,10F2,10F11,10F12,10F3 in a column.
When i sort them, it becames 10F1,10F11,10F12,F10F2,10F3,10F30.
How can i sort the codes in order 10F1,10F2,10F3,10F11,10F12,10F30
Posted by Aladin Akyurek on September 27, 2001 11:42 PM
Gokhan --
One way is to use an additional column.
Assuming that your codes are in A1:A6,
in B1 enter: =RIGHT(A1,LEN(A1)-SEARCH("F",A1))+0
Copy down this as far as needed.
Select A1:B6 and sort on B.
Aladin
