In Excel 2 columns data into one?

K

Kelgal123

I have a spreadsheet with several columns. I have a last name column and a
first name column and I want to merge the last name and first name into one
column instead of two. Help, I can't fugure this out.
 
G

Guest

in column c(or whereever) enter =concatinate(a1,", ",b1).
copy down. move new column to desired place. delete or
hide old a and b columns.
 
Top