01-10-2019 12:03 PM
01-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.
01-10-2019 06:00 PM
This information on this link explains how to merge text from two cells, but not two columns.
01-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.
01-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.
01-13-2019 04:18 PM
01-13-2019 04:53 PM
The column and row identifiers change for each cell, so this copy/paste method will not work.
01-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.