You are here:
- Home
- Computing/Technology
- Business Software
- Excel
- Sorting an Excel Address List
Excel/Sorting an Excel Address List
Advertisement
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?
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
Related Articles
- St. Paul Zip Codes - A List of Zip Codes in St. Paul - Zip Codes in the City of St. Paul and Ramsey County
- Minneapolis Zip Codes - Zip Codes in Minneapolis
- Postal Codes Canada - Look up Postal Codes for Canada
- Zip Code Look Up - Use the Web for Easy Zip Code Look Up
- San Francisco Schools - A List of San Francisco Schools by Zip Code
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Miguel Zapico
Expertise
I am recycling to Excel 2010, so I am taking an extended leave while I work on keeping myself an expert on this matter.
Experience
I have worked with Excel for the past 12 years, in various environments.
Organizations
NYPC (New York PC users group)
Organizations
NYPC (New York PC users group)
Education/Credentials
MCSE in Windows NT
©2012 About.com, a part of The New York Times Company. All rights reserved.