Alpha sort excel mail list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I purchased a mailing list (comma delimited). After visually scanning the
list, I find many duplications. It is a very large list. Is it possible to
alpha sort this data either by last name or by address so that it can be
edited more easily? The sort would need to also shift the adjacent cells so
that names and addresses remain correct.
 
Click in the box in the upper right hand corner of the worksheet (between Row
1 and Column A) to select all the cells in the sheet. Then click the Data tab
Sort select the name column or whatever column you wish to sort by, then
Click to expand...
click OK.
 
Gray button in Upper *left* hand corner -- at least in languages that read left to right.
Grey button (in English)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating Numerical and Alpha Data in cells 6
Auto sort function for a list 1
Data Sorting Problem 2
alpha-sort list where each entry contains more than one line 1
sorting sub groups in pivot tables 1
OL 2007 -- address book sorts 6
how do I sort an excel list that includes pictures (name-picture) 1
Columns not sorting properly. 2

Back
Top