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


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