I've saved my Outlook "distribution lists" to a .txt file and then imported them into Excel. I've combined those files with a file I had in Word of email addresses in an attempt to create a master email list for clients and customers. Anyway, now that I have one file, I'm trying to sort the file by email address and I get some crazy sort results. The entire list will sort but not correctly. It seems to start over from A to Z in certain spots... I've copied and pasted special as values... I've highlighted the columns and changed it all to text fields, same font etc... Still Excel is seeing something I'm not when it comes to the sort. I can highlight all and look for duplicates, that works fine... but when it comes to sorting it correctly it is hosed up. I'm using Office 2007... Any thoughts or advice?