Matching Names with two separate formats

Closed
Alex - Jun 22, 2016 at 10:13 AM
Hello,

I am trying to create a table where in one column has the names from File1 in format Last, First ex. Gates, Bill without duplicates. The in the second column the names from File2 which is in the format lastnamefirstinitial - Firstname Lastname ex. gatesb - Bill Gates.
The names in both columns have to match up and still preserve their respective formatting.

I'm at a loss of how to do this using only Excel formulas. I was thinking of =LAST() and so forth but i can't wrap my head around the logistics.
Any help or suggestions would be greatly appreciated.