Minor recommendation, I would keep the formula below but will change the -2
to -0 if you really need to display the entire name in column C. The -2
removes that number of characters from the name in C1. Other than that, this
formula works great.
--
tech1NJ


"Mike H" wrote:

Another

=LEFT(TRIM(C1),LEN(TRIM(C1))-2)&D1

Mike

"Mike H" wrote:

Hi,

In E1 and drag down

=LEFT(C1,(FIND("|",SUBSTITUTE(C1," ","|",2)))-1)&" "&D1

Mike

"Martin ©¿©¬ @nohere.net" wrote:

Hi
I have titles & names is two columns
in column c I have
Aiken Mr R.
Aiken Mrs C.
Bell Mr D.
Bell Mrs E.
etc, etc,

In column d I have
Robert
Carol
David
Elaine
etc, etc

How do I join the title/name to get
Aiken Mr Robert etc, etc
--
Martin
©¿©¬