In D1 enter the following

=B1&" "&C1

Drag it down as far as needed. Then copy the column and paste special
Values in column B. Delete column D

Does that work?


"GRK" wrote in message
...
My spreadsheet has two description columns. I want to merge column B & C
together without loosing any data. If I merge B & C together, I loose the
data in C. Is there any quick way to get this data to merge without
typing
each cell?

B C
PLATE 3/16 CLEAR 36X36
PLATE 3/16 CLEAR 36X38

Desired result:

B
PLATE 3/16 CLEAR 36X36

Thanks

GRK