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.
Enter the two parsing formulas as shown in yesterday’s example. Then, select the range.
From your keyboard, press
Alt+D+S to show the Sort dialog box.
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.
Not shown in a picture because it is optional, to delete the two helper columns.
Nifty trick we are always on the look out for tricks to better arrange our projects.
How to change the same to you too
No idea what your comment means.