View Single Post
  #7   Report Post  
John Mansfield
 
Posts: n/a
Default

Pete,

In a third column (say column C), add a formula that references column A and
B like this:

=A1 & " " & B1.

Copy the formula down the column C range for all of the rows involved in the
import.

----
Regards,
John Mansfield
http://www.pdbook.com

"Pete" wrote:

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.