How to merge columns

P

Pete

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.
 
W

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
[email protected]
 
P

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
 
S

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
 
V

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.
 
J

John Mansfield

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.
 
P

Philippe l. Balmanno

Paul B said:
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
Click to expand...
I like this one and =CONCATENATE(A:A," ",B:B) works for me as well.
 
Top