"Doug Kanter" wrote in message
...

"Mike" wrote in message
oups.com...
Here is my scenario:

I have column A (first name) and column B (last name).
I need to merge the to column a (first and last name).

Ho do I accomplish this?

Using Excel 2003

Sorry for what seems like a stupdily simple question!

Mike Biang
ASP/PHP/ASP.NET


=CONCATENATE(A3," ",B3)

That takes the value in A3, adds a space (shown between quotation marks),
and finally adds the value in B3. If you then copy the formula all the way
down the column, Excel will automatically change the line numbers (A3 to
A4, A5, etc). There's a way to stop that automation, but in this case, you
want it.

This formula has to go in a separate column, but if you have room in the
viewable part of the sheet, you can stick the new column way off to the
right somewhere. Then, copy the new, joined names into whatever column you
want, using Edit, Paste Special, Values.


Oops - type. Should've said "but if you DON'T have room..."