How to merge columns

[Guest]

How do I merge 2 columns, A & B, with A being the first name and B being the
last name. I have 2640 rows that need this completed in order to import in to
a database.

 

[William]

Pete

In cell C2 enter the formula
=A2&" "&B2
and then copy cell C2 down column C as far as you need.

You may then want to Edit>PasteSpecial>Values the data in Column C to change
the formulae to hard coded values.
---

XL2003
Regards

William
(e-mail address removed)

 

[Paul B]

Pete, here is one way, put this in C1 and copy down

=CONCATENATE(A1," ",B1)

then copy and paste special valves on that column if needed

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Stevie_mac]

Select Cell C2
Type =A2 & " " & B2
Press Enter
Select Cell C2 again
Grab the square dot on the bottom right of the cell & drag it down the 2640 rows

Now Column C will have "First_name Second_name" in populated from COL A & COL B

 

[Vasant Nanavati]

In cell C1 (assuming no header row), put the formula

=A1&" "&B1

Select column C and lock the entries using Edit | Copy | Edit | Paste
Special | Values.

Optionally, delete columns A and B.

 

[Vasant Nanavati]

Of course, copy the formula in Cell C1 down to the last of the 2640 rows.

 

[Guest]

Pete,

In a third column (say column C), add a formula that references column A and
B like this:

=A1 & " " & B1.

Copy the formula down the column C range for all of the rows involved in the
import.

 

[Philippe l. Balmanno]

Pete, here is one way, put this in C1 and copy down

=CONCATENATE(A1," ",B1)

then copy and paste special valves on that column if needed

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

I like this one and =CONCATENATE(A:A," ",B:B) works for me as well.