Combine multiple cells Excel

Let’s say in Excel you have values in A and B columns. And you want to combine those columns in column C.
CONCATENATE  function will help you. It can combine up to 30 cells in excel 2003, but 255 cells in excel 2007 and newer.Put this:


in cell C1. Based on settings, in some versions of excel you must use comma instead of semicolon.

Then place cursor on right lower corner until cross-cursor appears,  drag downwards thus placing formula in those cells


Additionally you can combine cell with some text value, for example


What to do if you need to combine many cells but you don’t want to write long long boring formula? Well then I recommend using this trial version of this plugin (free for 30 days) that will do other great stuff as well.