find, replace and rearrange a string

**lillianng** · 06-20-2013, 11:40 PM

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.

**FDibbins** · 06-21-2013, 12:09 AM

Hi and welcome to the forum

Why cant you just combine column D and column A?

=D1&", "&A1

**lillianng** · 06-21-2013, 06:12 AM

Originally Posted by FDibbins

Hi and welcome to the forum

Why cant you just combine column D and column A?

=D1&", "&A1

Elvira and Dale are usually not in order (in the same row).

Actually
Elvira & Elvira O'dell in 1 sheet
Dale and O'dell in another sheet.

**FDibbins** · 06-21-2013, 07:19 PM

Perhaps it would be easier to help if you upload a sample workbook so I can see what you are working with
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.