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

 

 HELPFUL RESOURCE:

hmb_logo_01Lg

6

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