| |
You are here: Experts > Computing/Technology > Microsoft Software > Excel > Sorting an Excel Address List
Excel - Sorting an Excel Address List
Expert: Miguel Zapico - 11/4/2009
Question
I need to sort an Excel Address database of 2500 addresses according to zip code for mail sorting purposes. The information is arranged into separate columns of NAME; ADDRESS; CITY; STATE; ZIP. For some reason, when I sort the list alphabetically by name, the list appears from A to Z without a hitch. But when I sort the same list according to zip code, the list is sorted into two different batches, so the same zip code appears in two different sections of the list. Do you give me any ideas on how to correct this response to sorting?
Answer
You are right, that shouldn't happen. The only explanation that I can think on is that some of the zip codes may have a quote before them, to signal them as literal text, and some other not. They will appear the same in Excel, but as they are not the same they will be sorted in separate areas.
Apart from that, I cannot think on other reasons for this behavior, sorry.
Hope this helps,
Miguel
Add to this Answer Ask a Question
|
|
