MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.