Compare and edit two excel spreadsheets

Take first list (txt file) containing names, phone numbers, and motorycle compare to a second list (txt files) containing names, phone numbers, and email list. If a name is on both list add the email address field to the firt list. Check for duplicates. And seperate the name field into first and last name.