How do I separate domains and usernames in one column to two columns in Excel?

DESCRIPTION

There are two ways to separate domains and usernames stored in one column in a spreadsheet.

Example: Column B stores username@domain.com and the goal is for column C to store only domain.com.

HOW-TO

Method 1:

This method provides one column with just the username and another with just the domain. In the example, column B would contain only "username", overwriting the complete address, and column C would contain only "domain.com".

Select the column containing the email addresses (column B in the example) > go to the DATA tab in Excel's toolbar > click "Text to Columns" in Data Tools in the toolbar > set Type to "Delimited", click next > set Delimiters to Other and enter @ in the box (uncheck any other Delimiters that are checked), click next > set Column data format to "General" and click Finish.

Method 2:

The formula below can be added to another column, replacing "B" in the example with whichever column contains the email addresses and updating rows accordingly.

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

This leaves the source column intact, outputting only the "domain.com" portion of an email address. Note that 255 is the number of characters.