Export email address to a new Excel column

Microsoft Excel 2010 - complete product...
December 10, 2012 at 22:14:57
Specs: Windows Vista
Dear all I have a list of the following data in cell A1, any quicker option for me to extract only the email address in to cell A2?

2;"msriegler876";;"msriegler186@yahoo.com";;"12782";;"0";"30351";"1";;"States";"Australia";;"msriegler876";;;;;;;;;;;"1";;;"0000-00-00 00:00:00";"0";"0";;"0";"0"


See More: Export email address to a new Excel column

December 11, 2012 at 05:11:18
Use the Text To Column function on the Ribbon:

Select cell A1
Select Data Tab
Click on Text To Column
Select Delimited, Click Next
Select Semi-colon, Click Next
Click Finish

Also, Excel questions are best asked in the Office Software forum.



Report •
Related Solutions

Ask Question