Get in Touch

  • Live Chat
  • Email Us
Call Us
  • INTL 001.562.252.3789
  • USA 800.430.4095
  • UK (+44) 20 3695 2266
  • Switzerland (+41) 43 508 4676

Frequently Asked Questions

was designed with your needs in mind. So, there is a good chance that you will find the answer to your question here. Plus, it is available to you 24 hours a day, 7 days a week.

Select a topic to start

Search by Topic

Search by Keyword

How do I sort by domain for email addresses in an Excel file?

To sort email addresses by domain, follow these steps:
  1. Create a copy of the Excel file.
  2. Open the copy of the file and click on the column to the right of the column containing the email addresses.
  3. Right click the column you just highlighted and select Insert. This creates a blank column that you will need later. Repeat this step so that there are two blank columns when you are finished.
  4. Copy the email ID column and paste it into the first blank column you just created. (This will give you a column to sort while still preserving the original column of addresses.)
  5. Now click on the column containing the copied email addresses.
  6. Click Data > Text to Columns.
  7. Select Delimited and click Next.
  8. Make sure the only box checked is Other and enter the @ symbol in the box.
  9. Click Finish.
  10. A window will pop up asking if you want to replace the contents of the selected cells. Select OK.

    Note: The email addresses are now separated into two columns. The first one contains the information before the @ symbol. The second one contains the information after the @ symbol, which is the domain.
  11. Save the file.
  12. Click Data > Sort.
  13. Select the column title you want to sort (the one containing the domains) and select how you want it sorted (for example A - Z).

Was this FAQ helpful? print up down

More related questions