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