Tom’s Tutorials For Excel: Sorting Email Addresses by Domain and Recipient

Tom’s Tutorials For Excel: Sorting Email Addresses by Domain and Recipient

Yesterday, I posted this method for parsing the recipient and domain names from an email address.

As an example of why you would want to separate a recipient name from its domain name, a common marketing task is to sort the company’s list of client email targets by client name (domain) and then by recipient name of that client.

The following pair of Before and After pictures shows an unorganized random list of client email addresses, and then that same list sorted in ascending order by domain name and recipient name.

This is accomplished in 3 easy steps, and 1 optional step.

Step 1
Enter the two parsing formulas as shown in yesterday’s example. Then, select the range.

Step 2
From your keyboard, press Alt+D+S to show the Sort dialog box.

Step 3
For whichever version of Excel you are using, indicate in the Sort dialog box that you want to sort the range by Domain in ascending order as the primary field, and then by Recipient in ascending order as the secondary field. Also indicate that your selected range has a header row.

Step 4
Not shown in a picture because it is optional, to delete the two helper columns.