Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alpha sort excel mail list
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. |
#2
|
|||
|
|||
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 OK. "bobalead" wrote: 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. |
#3
|
|||
|
|||
Gray button in Upper *left* hand corner -- at least in languages that read left to right.
Grey button (in English) "jmonty" wrote in message ... 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 OK. "bobalead" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
list of all excel 2000functions | Excel Discussion (Misc queries) | |||
How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
Excel 2003: Match one list against another and highlight differenc | Excel Worksheet Functions |