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

John (john@email.com)

 

…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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data.You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Dynamic Data Validation List What´s a dynamic data validation drop down list in Excel, you say?Well, as you add new data into your Excel Table, your drop down list automatically gets updated.That is a cool feature and it means that you do not need to update your data validation source reference each ...
Show The Percent of Parent Column Total With Excel...  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 PARENT COLUMN TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers suc...
Drop Down List with Data Validation One of the coolest features of Excel is to create a drop down list with your data.  It is one of the first things that I learned and use on a daily basis.You can create a drop down list to eliminate manual entry and re-entry of data, as well as reduce data entry mistakes if y...