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.