How to turn two columns in Excel into one without losing contents - concatenate not merge

To be honest I'd assumed the Merge function would sort that out, but no, it creates a single cell from two cells but deletes the content of one and so leaves you with half of your information. Merge is not the function you're looking for.

It turns out that it's Concatenate.

Here's a picture of what I had and what I wanted.

Obviously my first port of call was Twitter.

@JoBrodie make a third column and use concatenate, so basically C = concat(A,B) http://t.co/6MO2aDoZKj
— Lauren G (@geeoharee) October 14, 2014

@JoBrodie = A1 & " " & A2
— Spike (@tenbus_uk) October 14, 2014

I used the second suggestion and it worked, hooray.