<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>
></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>
></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>
