Excel Sorting postcodes in Excel

[lynnechapman]

I am trying to sort a list in Excel by postcode but it always files in the order
NG1
NG10
NG2
etc.
Is there a way that I can get it to put NG10 after NG9?
Thanks
Lynne

 

[gtgloner]

I think i might have a solution here, first put this formula in the cell next to the first entry in your list (this assumes that the list is in column A):

=MID(A1,3,20)

Copy down for however many rows you have and then highlight both the list column and the formula column and click Data-Sort from the menus. Make sure that you select the column of formulas to sort by, you might get a box that asks if you want to sort that column as if they were numbers, select this option and then OK. You should now have your original list sorted the way you indicated.

Glenn