How do I sort or separate email addresses in Excel?



To Separate email addresses in Excel:

Excel Create TablePrecaution: Make a copy of your list and work on the copy in case of errors.

1. Highlight your list and click on ‘Insert’
2. With the highlight still active click on ‘Table’
3. The ‘Create Table’ box will appear with the data rows already inserted. If your columns have headers click the small box next to ‘My table has headers’

NOTE: Make sure you highlight all the columns that contain information and not just the email column otherwise your list will be out of order.

Sort Excel Table4. Click on the down arrow on the heading of your email address column and click into the ‘Search’ box.
5. Type .edu, .com etc. if you wish to sort by extension.
6. Click ‘OK’ and the .edu addresses will appear on a separate list.
7. Click the ‘Undo icon’ to bring the list back to the original or save your changes. (You cannot use the ‘Undo’ feature if you have saved the changes)

To Sort email addresses Using Conditional Formatting:

Precaution: Make a copy of your list and work on the copy in case of errors.

1. Highlight your list.Excel Conditional Formatting
2. Click on ‘Conditional Formatting’
3. Click on ‘Highlight Cells Rules’
4. Click on ‘Text that Contains’
5. Type .edu in the box supplied.

Excel Highlighted TextAll the .edu email addresses will be colored red and you  can sort your list accordingly.
Conditional Formatting has many features in order to sort all your lists.

If you would like more help with this and other features please visit this page.

Posted in: Email, Excel Formulas, General, Microsoft Excel, Text