Excel 2007 : Zipcode sorting problem

Originally Posted by debrant

Were you able to do a sort so that it starts with "0" goes thru "9" and the zips with +4 are sorted thruout? For example
01256
01256-2000
01277
84454
84666-4444
93456
When I sort it, all the 5 digit zips come first then the 9 digit after.
Thank you.

This is what I got after sorting and using my formula. You can delete column E after sorting.. your column D is the one you want.

Originally Posted by debrant

I understand the part about creating column E, but how do you end up with the values in D that have dropped the "-0000"?

Do you think this can be simplified so that someone can add contacts and resort as needed? Seems amazing to me that something as common as a zip code sort is such a complicated problem! Thank you!

I left the D column as you had it, then I created the E column separately, and sorted by that column so that D remained untouched but sorted.