Hi all.
This in an annoying little problem which I am hoping there is a simple solution for by way of a formula or text to columns manipulation.
My raw data which is produced into a single cell is supposed to contain a name and then 2 spaces and an email address. Some of the cells contain the email address repeated twice in error. I need just the name and a single email address.
If eg cell A1 contains:
James Smith jsmith@ultra.com jsmith@ultra.com
How can I get rid of the duplication? Any suggestions GREATLY appreciated.
Thanks
This in an annoying little problem which I am hoping there is a simple solution for by way of a formula or text to columns manipulation.
My raw data which is produced into a single cell is supposed to contain a name and then 2 spaces and an email address. Some of the cells contain the email address repeated twice in error. I need just the name and a single email address.
If eg cell A1 contains:
James Smith jsmith@ultra.com jsmith@ultra.com
How can I get rid of the duplication? Any suggestions GREATLY appreciated.
Thanks