postal codes order in Excel

  • Thread starter jillysillybilly
  • Start date
J

jillysillybilly

I have a list in Excel that I need to sort by postcodes, but in its current
format, the postcodes (Column A) go like this, eg: BA1 then BA10 BA11 BA12
etc then BA2, but I want them to go BA1 BA2 BA3 etc. How do I do this?
 
T

Tony Jollans

British postal codes are a classic bit of British design. There isn't really
much you can do - you either have to hold (and sort) the district and area
separately or hold them as one in the format BA01, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I list postcodes in order in Excel? 10
Dragging Cell References/Formulas 5
Merging from an Excel file with graphics 1
vlookup and sumproduct combine issue 0
Sorting 4
Conditional Cell Formatting 9
Postal code to Area translation 2
transposing postal addresses 3

Top