find, replace and rearrange a string

I have Column A with First Name, Column B with old Full Name, and Column C Old last name, Column D with New Last Name

First Name |Old Full Name| Old Last Name |New Last Name
Elvira |Elvira O'dell |O'dell |Dale

Rows 1-50

I want Excel to look to Column A (Elvira) , find same name old Full Name in Column B (Elvira O'dell), find old last name (O'dell) in column C and match with new last name (Dale) in column D, and return name as Dale, Elvira

Please show me how to do this. Thank you.