Q: I need to update my websites' news mailing list and remove duplicates, how do I sort the email list in Microsoft Excel by the domain names only? By default Excel sorts everything in front of the @ symbol alphabetically, I need to sort alphabetically everything following the @ sign. Help!
using Data > Sort in Excel it is possible to do
this, but first we'll need to pre-format the email mailing list
First off, assuming all your email address are listed in Column A (one email address per row), create a second Column in the Excel document so we can use a formula to output only the data following the @ sign in Column A;
=MID(A1, FIND("@",A1, 1)+1, 255)
Paste the above formula
into the first cell of Column B, as you'll see, this formula outputs only the domain part of the email address. Click on that cell and hover the mouse over the bottom right-hand corner of the box until you see the cursor turn into a "+" sign. Now click and drag the checkered box down to the very last row of data to copy the formula across all rows.
Next, select all your data by highlighting
Column A and Column B in the margins, then go to Data > Sort >
and under 'column' choose 'column B' and press 'okay'. This will
tell Excel to sort all the data, alphabetically by the domain names
in Column B, from there you can easily find and remove