<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. All are on the same line.
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> |
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>
