How do I sort a list of email addresses by domain in Excel?
Sort a list of email addresses by domain in Excel
Sorting a list contact email addresses by domain in Excel can be done quickly by adding an extra column containing just the domain names and then sorting on that column. You data remains intact, but in domain-name order when you're finished. When you're in Excel:
- Copy your file and then open the copy.
- Select the data in your list.
- Click Data > Text to Columns.
- Select Delimited and click Next.
- Under Delimiters, uncheck anything that is selected and check Other.
- In the box next to Other enter the @ symbol.
- Click Next, then Finish. This will generate two columns. The second column is just the domain.
- Copy the second column then open the original file.
- Add a new column next to the column with your contacts, then paste the copied column into the first file. Make sure the pasted column lines up perfectly with the contacts column.
- Select all of the cells in your spreadsheet.
- Click Data > Sort.
- In the Sort by field choose the column that contains only the domain names that you pasted in. Click OK. This will group all the addresses with the same domain together.
- You can delete the column with just the domain name when you're finished.
Excel is not a Constant Contact product. For more information, please refer to http://support.microsoft.com