merging cells and keeping all data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 columns, first name and last name.

I would like to merge these 2 columns into one, keeping both data sets.
Is there a simple way to process this action without manually adjusting
everything? I have over 1000 to maintain.

Thanks,
 
With names in A2 and B2, enter the following formula in cell C2:

=A2 & " " & B2

Copy the formula down to the last row of data
 
Back
Top