How about

=IF(OR(B1=D1,D1=""),A1&" & "&C1,A1&" "&B1&" and "&C1)



"Linda G" wrote:

Primary First Primay Last Secondary First Secondary Last First Last
John Smith Debbie John & Debbie
Carl Overstreet June Overstreet Carl & June
Robert Johnson Susan Devers

I have the formula that combines the primary first and primary last name if
the Primary Last Name is either the same as the Secondary Last Name or the
Secondary Last Name is blank. =IF(OR(B1=D1,D1=""),A1&" & "& C1,"") I need to
add to this a formula that will combine the Primary First, Primary Last, &
the Secondary First Name into the First Name Column when the Primary Last
Name and the Secondary Last Name are not the same.