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 EditPasteSpecialValues the data in Column C to change
the formulae to hard coded values.
---

XL2003
Regards

William



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