Joining/Merging Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to merge two cells into one and then, eliminate the 2d cell, e.g.,

Cell A Cell B
Smith James
Jones Fred

CELL A now becomes
Smith, James
Jones, Fred

I know about =Ax&", "&Bx [where x is the row number]; however, I do NOT want to keep
column 2 after I complete the merger. However, if after I merge, and obtain the result I want, I
don't know how to retain the result after I delete Column B. So, "adding" effectively adding the
two columns together doesn't cut it.

Thanks!
 
Ann

just select the merged data, Copy it and then Paste Special | Values back
over the top

Regards

Trevor
 
Thank you ever so much! I just knew that it could be done somehow but, the "how" was the question
 
Back
Top