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

Share on Google+

Google+

Related Posts

Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error. This means that the formula refers to a cell that isn’t valid. To get rid of this error message we have to select the cell(s) with this error, ...
Excel Paste Special: A Values Multiplier Paste Special has a few different Paste features and operations that many users do not know about. One of them is the Paste Special > Values > Multiply combination. What that does is multiply a range of selected cells by a value, called the multiplier.  So if you want...
Show The Percent Of With Excel Pivot Tables   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation. It will display the value of one item (the Base Field) as the percentage of another item (the Base Item). This optio...
Unpivot Data Using Excel Power Query Power Query is a free add-in created by Microsoft for Excel 2010 (or later) and you can download and install it for Excel 2010 and 2013: Click to see tutorial on how to install Power Query in Excel 2013 Click to see tutorial on how to install Power Query in Excel 2010 In...