Joining/Merging Cells

[Ann]

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!

 

[Trevor Shuttleworth]

Ann

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

Regards

Trevor

 

[JE McGimpsey]

If you've used column C to merge the data, then copy column C, select
column A and choose Edit/Paste Special, selecting the Values radio
button. Delete columns B & C

To automate the merge into column A, take a look here:

http://www.mcgimpsey.com/excel/mergedata.html

you can then delete column B.

 

[Ann]

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