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

--

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.