Originally Posted by
harrywaldron
Hi Ferdie - Copy/Paste won't take multiple columns and automatically combine them as it'll take the A/B cells and make C/D cells (if "C" is the blank target). You might try the following idea of combining cells by formula:
How to combine 2 cells into one:
Presuming the two columns you want to combine are A and B and they are on the 1st row, put this in cell C1, and copy it down the length of your data
With a space
=A1&" "&B1
With no spaces
=A1&""&B1
Combine 3 Cells with no spaces
=A1&""&B1&""&C1
Bookmarks