Sorting Zip Codes

[Leslie]

I have a mailing list that contains both 5 and 9 number
zip codes. When I ask to sort it first sorts the 5
number and then the 9 numbers. How can I combine them?

 

[ElsiePOA]

One way:
insert 2 helper columns next to the zip codes. Then use "Data", "Text
to COlumns" to seperate the first 5 numbers from the other four. Then
do a sort using the 5 number column as the first sort and the 4 number
column as the second sort. (Be sure to highlight ALL of your data).
Once the sort is completed, you can delete the helper columns and
you're done.