excels at mediocrity

Another trick I learned but then forgot about.

Merging two cells in excel without losing content is pretty easy, but you have to follow a few steps to get it nice and clean if you’re using the final result for a feed into a database or something. I have two cells I am trying to merge the html contents of both into one.

To Combine the Contents:

Column A has content

Column B has content

In column C type the following:  =a1&” “&b1

you can then highlight and entire column if you want and paste this and it will combine the contents of column A with Column B and leave a space in between. If you don’t want the space, enter =a1&”"&b1 instead with no space between the quotes.