I have two spreadsheets with employee names on them. They are the same
employees but they come from two different systems. The names in one of the
systems sometimes have mispellings. I join the two spreadsheets by employee
name and when I do the one that are mispelled in one spreadsheet do not pull
over to the other spreadsheet. Is there a way that I can cross reference or
get the spreadsheets to recognize they are the same every time I pull the two
spreadsheets together without manually changing each name every time. I can
sometimes have twenty to thirty names that are mispelled.