Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

How to split a list of email addresses to separate the username from domain in Excel

Posted on February 23, 2021 By rich No Comments on How to split a list of email addresses to separate the username from domain in Excel

I’ve often been provided with a list of email addresses and been tasked with creating users from the list.
A quick way to create the users is to bulk create them, but when it’s provided in email address format thats no good.
Here is how we can split them, and it’s really easy.

1. Title the colum to the right of the email list “username”


2. Select the Email addresses and on the Data ribbon, click the “Text to Columns” button in the data tools group.

3. Select “Delimited” and click next:

4. Uncheck all tickboxes accept for “Other” and enter the ‘@’ symbol, then click next.

5. Next you can choose the column data type; General is fine for this then click “Finish”.

6. The colums will be split, removing the @ symbol.




Post navigation

❮ Previous Post: SQL: Information on SQL Server Editions and Features
Next Post: SQL: Create a Database ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown