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.
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.
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 ,,firstname.lastname@example.org,2,,,"2016-08-23 08:03:14",22.214.171.124,,,,,,,,"2016-08-23 08:03:14",114852441,41260214da, ,,Rucksana4567@gmail.com,2,,,"2016-08-27 13:43:09",126.96.36.199,,,,,,,,"2016-08-27 13:43:09",114951541,126badcb6b, ,,email@example.com,2,,,"2016-08-28 08:03:49",188.8.131.52,,,,,,,,"2016-08-28 08:03:49",114954829,982835bc1a,
This question generated 29 answers. To proceed to the answers, click here.
This thread is current as of March 24, 2017.