<o></o>
I have two lists of emails to compare with each other.<o></o>
The first list is on excel, and the second list is on word.<o></o>
<o></o>
The list of emails on excel is on a column as shown below. <o></o>
<tbody>
</tbody>And the second list which is copied pasted from outlook onword is as shown below.<o></o>
smith, john < johnsmith@hotmail.com >; mathew, peter < mathewpeter@hotmail.com > ; sharma,monica < monicasharma@hotmail.com > ; mark,jacob <markjacob@hotmail.com ><o></o>
<o></o>
I want to compare both lists to capture discrepancies. <o></o>
I have two lists of emails to compare with each other.<o></o>
The first list is on excel, and the second list is on word.<o></o>
<o></o>
The list of emails on excel is on a column as shown below. <o></o>
JOHNSMITH@HOTMAIL.COM<o></o> |
MATHEWPETER@HOTMAIL.COM<o></o> |
MARKJACOB@HOTMAIL.COM<o></o> |
PAULDOUMIT@HOTMAIL.COM<o></o> |
<o></o> |
<tbody>
</tbody>
smith, john < johnsmith@hotmail.com >; mathew, peter < mathewpeter@hotmail.com > ; sharma,monica < monicasharma@hotmail.com > ; mark,jacob <markjacob@hotmail.com ><o></o>
<o></o>
I want to compare both lists to capture discrepancies. <o></o>