Excel question?

Question

I'd like to merge the contents of two columns whilst maintaining their contents. How do I do this?

Example of current state of spreadsheet:
Column1 Column2 Column 3
Screen manufacturer Screen size Screen Type
Dell 21" TFT
Dell 24" TFT
Panasonic 32" LCD

Instead of three columns I'd like 1 single column containing all that information: ie.

Column1
Screen
Dell 24" TFT
Dell 19" TFT
Panasonic 32" LCD

Any help in doing this would be much appreciated, I'm sure it can't be too complicated. I have a vague recollection that the function for doing this is called "Concatenate" although I might be wrong.

That didn't come out very well in this text editor... in the original example (current state) each piece of information is in a different column. ie. Column one contains DELL, column 2 contains 21", column 3 contains TFT etc.

thanks for the answer. Any chance you could tell me how to apply this concatenation to an entire column - I have over 3000 entries and don't really fancy doing them one by one. Cheers!

Answer 1

Use the Concatenate function. Create a new column to the right of your three existing columns and enter the following formula :

=CONCATENATE(A1," ",A2," ",A3)

To apply to the whole column double click on the back dot in the bottom right hand corner of the cell and it should copy all the way down.

Answer 2

either use concatentate:

=CONCATENATE(A1," ",B1," ",C1)

or

=A1&" "&B1&" "&C1