Forum Discussion
Combine two Excel columns without losing data
I need a way to combine two Excel columns without losing data. I would like a method which is fast and easy.
14 Replies
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.
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.
