sorting contacts

D

docbaer

Hello,

I am trying to sort my Outlook contacts by exporting them to Excel and then
doing an ascending sort. However, Excel doesn't seem to sort more than 300
rows for me. It starts a new sort after doing 300. Is that a limitation of
sorting in Excel? Is there a solution?

Eugene Baer
 
D

Dave Peterson

Make sure you select the entire range to sort.

If you let excel guess the range to sort, it can ignore things separated by
blank rows/columns.
 
M

mrice

Sounds to be more a data problem.

It would be worth trying copying the list into notepad first to remove
any fancy characters that might be confusing Excel and then copy from
notepad to Excel.
 
Top