View Single Post
  #3   Report Post  
 
Posts: n/a
Default

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.

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