Need Help Merging Cells

[trvlnmny]

I have 2 columns of data that I want to merge into 1 column. I first
inserted a blank column and thin I used =Concatenate(c1," ",d1). I
then copied the formula down the new column. This worked fine giving
me the contents of the 2 cells in one cell. I then deleted columns C &
D and the trouble began. The values in the new column were no longer
valid as the formula referred to the 2 columns that no longer existed.
How can I accomplish this"
Thanks for the help.

 

[Walter Briscoe]

In message <[email protected]
s.com> of Fri, 4 Mar 2011 03:41:38 in microsoft.public.excel.newusers,

I have 2 columns of data that I want to merge into 1 column. I first

I infer from your example that you want the result to consist of the
first column value, a space, and the second column value

inserted a blank column and thin I used =Concatenate(c1," ",d1). I
then copied the formula down the new column. This worked fine giving
me the contents of the 2 cells in one cell. I then deleted columns C &

At this point select the column which has the results.
Copy it to the clipboard. (Ctrl+C)
Click Edit\Paste Special\Values\OK
If you now look at an entry in the result column, you should see it has
the values without the formulas.

D and the trouble began. The values in the new column were no longer
valid as the formula referred to the 2 columns that no longer existed.
How can I accomplish this"

You can now delete columns C & D

 

[trvlnmny]

In message <[email protected]
s.com> of Fri, 4 Mar 2011 03:41:38 in microsoft.public.excel.newusers,


I infer from your example that you want the result to consist of the
first column value, a space, and the second column value


At this point select the column which has the results.
Copy it to the clipboard. (Ctrl+C)
Click Edit\Paste Special\Values\OK
If you now look at an entry in the result column, you should see it has
the values without the formulas.


You can now delete columns C & D

Thank you, that did it.