find, replace and rearrange a string

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.