I have a list of email address, in the format, 'Firstname.Lastname@Companyname.com'. My issue arises where multiple managers are serving the same function, these cells contain more than one email address in the aforementioned format, split by a ' ; '. Eg 'Firstname.Lastname@Companyname.com; 'Firstname.Lastname@Companyname.com ...'
Now I am only interested in extracting the first and last name of these managers, whether that be a single email address or a cell contains multiple. I understand the VBA function SPLIT will work, but I am unsure on how to code it.
I already have VBA code to remove duplicates.
Thank you in advance.
Now I am only interested in extracting the first and last name of these managers, whether that be a single email address or a cell contains multiple. I understand the VBA function SPLIT will work, but I am unsure on how to code it.
Cell Formulas | ||
---|---|---|
Range | Formula | |
L998:L1004 | L998 | =RemoveDupeWords(K998,"; ") |
I already have VBA code to remove duplicates.
Thank you in advance.