=CONCATENATE(D2,C2)
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"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?
--
Martin
©¿©¬
.