Pinterest Pixel

Text to Columns – Emails

John Michaloudis
If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like:
Text to Columns - Emails | MyExcelOnline Text to Columns - Emails | MyExcelOnline

John ([email protected])

 

…then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate column.

See how this is done with the following short tutorial.

Text to Columns - Emails | MyExcelOnline
Download workbookText-to-Columns-Emails.xlsx

STEP 1: Let us add a new column for us to place the Email addresses in.

Right-click on the Year Column header. Go to Insert > Table Columns to the Left

Make sure to rename the new column header to Email.

Text to Columns - Emails

STEP 2: Now we have a blank Email column. Select the values of the Name & Email column.

Text to Columns - Emails

STEP 3: Go to Data > Text to Columns

Text to Columns - Emails

STEP 4: Click Next.

Text to Columns - Emails

We want to split the Name & Email value by the (.

To do this select Other and populate inside. Click Next.

Text to Columns - Emails

The preview of the conversion looks good. Click Finish.

Text to Columns - Emails

Click OK.

Text to Columns - Emails

STEP 5: Now we have the Email column populated.  The last step is to remove the ) at the end.

Select the values of the Email column.

Text to Columns - Emails

STEP 6: Let us do a replacement of the values. Press CTRL + H.

Place ) in the Find what and click Replace All. This will replace the with a blank value, resulting in it getting completely removed.

Text to Columns - Emails

Now we have our names and emails separated!

Text to Columns - Emails

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Distinct or Unique Count with Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...