Jan 10 2019 12:03 PM
I need a way to combine two Excel columns without losing data. I would like a method which is fast and easy.
Jan 10 2019 02:37 PM
What do you mean by combine? Text or numbers? What are you looking for the result to be?
Jan 10 2019 05:04 PM
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.
Jan 10 2019 06:00 PM
This information on this link explains how to merge text from two cells, but not two columns.
Jan 11 2019 06:00 AM
I would like to merge the two columns of text into one column of text.
Jan 11 2019 06:55 AM
The Merge and Center option on the Excel ribbon loses data.
Jan 11 2019 07:33 AM
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.
Jan 11 2019 06:44 PM
Any option I find involves loss of data.
Jan 12 2019 03:24 AM
If you have data in A1 to A10 and B1 to B10 then in C1 type = A1&B1 then copy this formula down.
Jan 12 2019 11:01 AM
How do I copy the file down?
Jan 13 2019 04:18 PM
Jan 13 2019 04:53 PM
The column and row identifiers change for each cell, so this copy/paste method will not work.
Jan 13 2019 07:32 PM
Jan 15 2019 05:01 AM
I combined a sample Excel file with two columns of text. The difference with the real Excel file is that I have over two thousand lines of text, so a manual copy/paste will not be useful. Also, the version of Excel I am using does not have Power Query.
Jan 15 2019 04:58 PM