View Single Post
  #3   Report Post  
Old December 7th 04, 04:10 PM
Posts: n/a

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.