If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like:

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.

YouTube video

Text to Columns - Emails | MyExcelOnline

DOWNLOAD WORKBOOK

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 | MyExcelOnline

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

Text to Columns - Emails | MyExcelOnline

STEP 3: Go to Data > Text to Columns

Text to Columns - Emails | MyExcelOnline

STEP 4: Click Next.

Text to Columns - Emails | MyExcelOnline

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

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

Text to Columns - Emails | MyExcelOnline

The preview of the conversion looks good. Click Finish.

Text to Columns - Emails | MyExcelOnline

Click OK.

Text to Columns - Emails | MyExcelOnline

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 | MyExcelOnline

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 | MyExcelOnline

Now we have our names and emails separated!

Text to Columns - Emails | MyExcelOnline

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin