Assuming names are not all in C2 or D2 but rather in columns C and D

In E2 enter =D2 & " " & C2

Copy down.

If all in one cell, how are they separated?


Gord Dibben MS Excel MVP

On Tue, 23 Mar 2010 16:00:14 +0000, Martin ©¿©¬ @nohere.net wrote:

Hi
I have several lists of names
In C2 i have
Mr & Mrs E.
Mrs E.
Rev. G. & Mr M.
Mrs M.
Mr & Mrs J.
etc etc

in D2 I have
McAllister
Hay
Farquhar
Russell
Cuthbert
etc etc

How do I create a list in E2
McAllister Mr & Mrs E.
Hay Mrs E.
etc etc?