Did you check to see if you were looking at formulas?

If that's a yes, then I don't have any other suggestions.

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

On Wed, 24 Mar 2010 10:21:12 -0500, Dave Peterson
wrote:

Explain each step you've tried -- in great detail.
Did you reformat the cell to General?
yes
Did you reenter the formula?
yes
Did you copy the formula down using the autofill handle?
yes




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

On Wed, 24 Mar 2010 09:09:59 -0500, Dave Peterson
wrote:

How did it not work?
If you got the same results, then try it again. I'd guess you missed a step.
Or...
You may be looking at formulas.
Tools|Options|view tab|uncheck formulas (in xl2003 menus)

Did it again, several times
I still get =D2 & " " & C2 in each cell

I'm using 2007
--
Martin
©¿©¬


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

On Wed, 24 Mar 2010 07:04:12 -0500, Dave Peterson
wrote:

Format the cells as General (or anything but Text).

Then reenter the top formula and drag down again.

That didn't work either Dave
My colums have a header row if that makes a difference
--
Martin
©¿©¬

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

On Tue, 23 Mar 2010 09:27:57 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

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

In E2 enter =D2 & " " & C2

Copy down.

This didn't work Gord
I just got =D2 & " " & C2 in every cell ?
--
Martin
©¿©¬


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?

--

Dave Peterson