Sorting a list of UK Postal codes in Excel 2003

  • Thread starter Thread starter Mikey29
  • Start date Start date
M

Mikey29

Hi, I am relatively new to Excel and am using the 2003 version. I am
currently learning about lists. I have compiled a list of personal
data with names and addresses. I have put the Postal Codes in a
separate column.
When I sort the list in ascending order by Postal code I get e.g the
following:

SA1
SA11
SA12
SA5
SA6
SA8

Can anyone please advise how I can sort SA5,SA6 and SA7 to come before
SA11 and SA12 in the list.
Many thanks
 
Add another column and use a formula like this to convert the 3 digit
entries to 4 digit entries. Then sort on the new column.

= if(len(A1) = 3, left(A1,2) & "0" & right(A1,1), A1)

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Back
Top