Hi all, Does anybody here know whether it's possible to run some kind of script or macro to delete all text in an excel sheet except for the e-mail addresses in it? I have exported a mailing list from MailChimp, but I can't import it anymore, because the export made a very messy file. This is an example of what I have. Code: First Name,"Last Name","Email Address",MEMBER_RATING,OPTIN_TIME,OPTIN_IP,CONFIRM_TIME,CONFIRM_IP,LATITUDE,LONGITUDE,GMTOFF,DSTOFF,TIMEZONE,CC,REGION,LAST_CHANGED,LEID,EUID,NOTES ,,[email protected],2,,,"2016-08-23 08:03:14",18.104.22.168,,,,,,,,"2016-08-23 08:03:14",114852441,41260214da, ,,[email protected],2,,,"2016-08-27 13:43:09",22.214.171.124,,,,,,,,"2016-08-27 13:43:09",114951541,126badcb6b, ,,[email protected],2,,,"2016-08-28 08:03:49",126.96.36.199,,,,,,,,"2016-08-28 08:03:49",114954829,982835bc1a, So what I want, is to delete ALL the text except for the mail addresses. Does anybody know if this is possible? I'm using Excel on a Macbook Pro.
This question generated 29 answers. To proceed to the answers, click here.
This thread is current as of March 24, 2017.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel