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.

DOWNLOAD WORKBOOK

Text to Columns - Emails

 HELPFUL RESOURCE:

hmb_logo_01Lg

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

Related Excel Tutorials