Stuff that occurs to me

All of my 'how to' posts are tagged here. The most popular posts are about blocking and private accounts on Twitter, also the science communication jobs list. None of the science or medical information I might post to this blog should be taken as medical advice (I'm not medically trained).

Think of this blog as a sort of nursery for my half-baked ideas hence 'stuff that occurs to me'.

Contact: @JoBrodie Email: jo DOT brodie AT gmail DOT com

Science in London: The 2018/19 scientific society talks in London blog post

Tuesday, 14 October 2014

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.

I used the second suggestion and it worked, hooray.


  1. Wheeee - a honourable mention in despatches :) @tenbus_uk

    1. :) Well I'd never have worked it out by myself so I'm grateful to everyone that replied with the useful info. Yours looked the easiest and it worked fine therefore I've adopted it as my new method for future concatenations.


Comment policy: I enthusiastically welcome corrections and I entertain polite disagreement ;) Because of the nature of this blog it attracts a LOT - 5 a day at the moment - of spam comments (I write about spam practices,misleading marketing and unevidenced quackery) and so I'm more likely to post a pasted version of your comment, removing any hyperlinks.

Comments written in ALL CAPS LOCK will be deleted and I won't publish any pro-homeopathy comments, that ship has sailed I'm afraid (it's nonsense).