ExcelBanter - Sorting zip codes

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sorting zip codes (https://www.excelbanter.com/excel-worksheet-functions/239661-sorting-zip-codes.html)

Carol Lei

Sorting zip codes

Can I sort five-digit and nine-digit zip codes together?

Sean Timmons

Sorting zip codes

You would want to normalize the 5 digit zips to 9 digit. you can use formula
like so:

=if(len(A2)=5,A2&"-0000",A2) to give your 5 digit a -0000. Copy and paste
special, values. Then, you can do your sort off this new list

"Carol Lei" wrote:

Can I sort five-digit and nine-digit zip codes together?

All times are GMT +1. The time now is 03:57 AM.