How do I merge column contents

M

Mike

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
 
D

Doug Kanter

Mike said:
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
Click to expand...

=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.
 
V

via135

hi!

let us assume first name in A1, last name in B1
in C1 enter =A1&B1 which will give the full name!

-via135
 
D

Dave O

No such thing as a stupdi question.

Insert a new column to the left of A: this will be column A, first name
is now column B, last name is now column C. In the first relevant cell
of column A (call it A1), enter this formula:
=B1&" "&C1
This merges the value of B1 and C1 with a space in between.

If you need to convert this to text, highlight all of column A, copy it
to the clipboard, then click >Edit >Paste Special, select Values, and
click OK.
 
D

Doug Kanter

Doug Kanter said:
=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.
Click to expand...

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

Doug Kanter

via135 said:
hi!

let us assume first name in A1, last name in B1
in C1 enter =A1&B1 which will give the full name!

-via135
Click to expand...

He might like to have a space between the names. Can your method do that?
 
Top