Hello Excel gurus,
I have extracted emails from Outlook to CSV. Sorry if this has been asked before.
Am looking for a way to have all emails in one column so I can keep unique values.
I have extracted emails from Outlook to CSV. Sorry if this has been asked before.
Column1 (found in A1) | Column2 | Column3 |
To: (Address) | CC: (Address) | BCC: (Address) |
email1@domainx.com | ||
email2@domainy.com | email3@domainz.com;email4@domain1.com; | email4@domainz.com;email5@domain1.com;email6@domainz.com;email7@domain1.com (and a lot more emails here) |
email8@domain5.com; email9@domain6.com | email1@domainb.com (and a lot more emails here) |
Am looking for a way to have all emails in one column so I can keep unique values.