Forum Discussion
Combine two Excel columns without losing data
What do you mean by combine? Text or numbers? What are you looking for the result to be?
Any option I find involves loss of data.
If you have data in A1 to A10 and B1 to B10 then in C1 type = A1&B1 then copy this formula down.
How do I copy the file down?
There are ways to combine data from two cells into one cell. But, I am unable to find a way to combine the data from two entire columns.
The Merge and Center option on the Excel ribbon loses data.
I would like to merge the two columns of text into one column of text.
The initial two columns consist totally of text. The combined column will be totally text, with the second text string connected to the first text string.
This information on this link explains how to merge text from two cells, but not two columns.
https://support.office.com/en-ie/article/combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6
