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