How to merge info

[GRK]

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

 

[Gaurav]

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]

Gaurav,

The info you provided is great and will eliminate many hours of data input.
One more question. In following your advice, the results are that the two
cells merged, but I need a space between the two cells.

This is how the info is merging together.

PLATE 3/16 CLEAR36X36

Notice there is no space between the word CLEAR and 36X36

How do I get the space between the two cells?

Thanks

 

[Gaurav]

It should be adding a space between 2 cells. If you look at the formula, it
says B1&" "&D1. there is a space between the " and ".

if you are typing the formula yourself make sure to have space there.

 

[GRK]

Thanks, it worked.
--
GRK

It should be adding a space between 2 cells. If you look at the formula, it
says B1&" "&D1. there is a space between the " and ".

if you are typing the formula yourself make sure to have space there.