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