I have a database of circa 50k details and the email addresses have somehow become mismatched to the contact details.
<o
> </o
>
I was wondering if there was a way of matching the majority of the emails back to the contact details.
<o
> </o
>
There are multiple columns (around 15), but a few more important than others.
Column A = Company Name
Column B = email address
Column C = First Name
Column D = Last Name
Column E = Full Name
<o
> </o
>
Obviously, In most cases part of A will be in B. i.e. A = EXCEL Ltd, and B includes @EXCEL.co.uk.
<o
> </o
>
Further to this, the emails (B) will usually include some of C, D or E.
<o
> </o
>
i.e. if name is John Smith, then email will be Smithj@, or johns@ or jsmith@.
<o
> </o
>
Due to my lack of Excel experience, I was wondering if there was a way of sorting this data, or if I was just stuck?
<o
> </o
>
Thanks in advance on any tips!
<o
I was wondering if there was a way of matching the majority of the emails back to the contact details.
<o
There are multiple columns (around 15), but a few more important than others.
Column A = Company Name
Column B = email address
Column C = First Name
Column D = Last Name
Column E = Full Name
<o
Obviously, In most cases part of A will be in B. i.e. A = EXCEL Ltd, and B includes @EXCEL.co.uk.
<o
Further to this, the emails (B) will usually include some of C, D or E.
<o
i.e. if name is John Smith, then email will be Smithj@, or johns@ or jsmith@.
<o
Due to my lack of Excel experience, I was wondering if there was a way of sorting this data, or if I was just stuck?
<o
Thanks in advance on any tips!