merging cells and keeping all data

[Andrew]

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,

 

[Barb Reinhardt]

Try concatenating them instead of merging them.

 

[Debra Dalgleish]

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