Use Excel to split Email Addresses into Username and Domain columns

Use Excel to split Email Addresses into Username and Domain columns

When working with contact data, you may need to isolate the domain portion of an email address—for example, extracting domain.com from username@domain.com. This is useful for segmentation, reporting, or domain-based analysis. Below are two simple methods to separate usernames and domains stored in one column of a spreadsheet.

Method 1: Use Excel’s Text to Columns Tool

This method splits the email address into two separate columns—one for the username and one for the domain—by using the @ symbol as a delimiter.

Steps:

  1. Select the column containing email addresses (e.g., Column B).
  2. Go to the Data tab in Excel’s toolbar.
  3. Click Text to Columns under the Data Tools section.
  4. Choose Delimited and click Next.
  5. Under Delimiters, check Other and enter @ in the box. Uncheck any other options.
  6. Click Next, then choose General as the Column data format.
  7. Click Finish.

The result:

  • Column B will show only the username (e.g., username)
  • Column C will show only the domain (e.g., domain.com)

Tip: This method replaces the original email column with just the username, so it’s a good idea to copy your original data elsewhere first if you want to preserve it.

Method 2: Use a Formula to Extract the Domain

If you prefer to keep your original email addresses intact, use the following formula to extract the domain portion only:

=MID(B1,SEARCH("@",B1)+1,255)

How it works:

  • SEARCH("@",B1) finds the position of the @ symbol.
  • MID extracts everything after it, up to 255 characters.

Usage:

  • Enter the formula in a new column (e.g., Column C).
  • Replace B1 with the actual cell reference that contains the email address.
  • Drag the formula down the column to apply it to the full list.

This method is ideal for creating a clean domain column while leaving your source data untouched.

Best Practices and Tips

  • If you’re working with a large dataset, formulas may be easier to scale without overwriting data.
  • For one-time cleanups or static lists, Text to Columns offers a quick visual solution.
  • Always back up your data before performing bulk edits in Excel.

Practical Use Cases

  • Segmenting contacts by domain (e.g., all gmail.com users).
  • Analyzing corporate vs. personal email addresses.
  • Identifying duplicate or unusual domains in your database.
If you have any questions or need help, feel free to reach out to our Support team by emailing us at support@delivra.com.

    • Related Articles

    • Using the Split Clause

      Sometimes you need to divide your contact list into equal parts to test different messages, subject lines, or timing strategies. Rather than manually separating your list, Delivra offers a Split Segment clause that automates this process with ...

    • Changing the Email Addresses for Contacts

      Delivra uses the email address as the primary identifier for contacts. This means that if you import a new email address, Delivra will treat it as a new contact. But what if you simply need to update an existing contact's email address—whether it's a ...

    • Managing your Email and SMS contacts

      The Contacts dashboard is your central hub for managing subscriber records in Delivra. Here, you can view, import, and update your contacts across two distinct communication channels: Email and SMS. These contact types are stored and managed ...

    • Should I include Listserv addresses in my contact list?

      It's a common question among B2B and higher education clients: Can I send a campaign to a distribution list (also known as a listserv)? While it's technically possible, the more important question is—should you? Our strong recommendation is no, you ...

    • Linking Email and SMS Contacts

      When managing SMS and email subscribers in Delivra, it's helpful to know whether a contact’s email and mobile number are linked within your account. This connection determines how easily you can manage, segment, and communicate with contacts across ...