| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | CLICK THE CELLS TO VIEW THE FORMULAS AND READ COMMENTS | ||||
2 | Raw Names | Comparison Names | Punctuations marks to Remove | Raw Names - Cleaned | Comparison Names - Cleaned |
3 | Jon.Smith | Tom Smith | ,'-. | Jon Smith | Tom Smith |
4 | MARY-JANE | peter smith | MARY JANE | peter smith | |
5 | j.smith | alice wong | j smith | alice wong | |
6 | Alice.Wong | Sarah Lee | Alice Wong | Sarah Lee | |
7 | Bob.O'Reilly | john smit. | Bob O Reilly | john smit | |
8 | sarah-lee | Lucy-Liu | sarah lee | Lucy Liu | |
9 | TOM.SMITH | Mary Jane | TOM SMITH | Mary Jane | |
10 | emily.jones | bob o'reilly | emily jones | bob o reilly | |
11 | PETER.SMITH | J-Smith | PETER SMITH | J Smith | |
12 | lucy.liu | Emily-Jones | lucy liu | Emily Jones | |
13 | |||||
14 | |||||
15 | |||||
16 | |||||
17 | |||||
18 | |||||
19 | |||||
20 | |||||