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

"Pete" wrote in message
...
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.