How to combine two columns in excel with a comma

Excel offers three distinct functions as well as a fourth way to combine multiple text cells into one cell. There are countless examples in which you might need this: Combine given- and family names or preparing primary keys for multi-conditional lookups.

For example, in a VLOOKUP or INDEX/MATCH formula combination.

Merge two cells in excel formula

In this article you learn five methods and in the end, you learn how to deal with a large range of cells.

Method 1: &-sign

The easiest way is probably to just use the “&”-sign to combine values in Excel.

This method has the same disadvantages like the CONCATENATE function from the method 4 below. It can only regard single cells and not ranges of cells. An advantage of this method is that it’s usually easier to follow up the calculation steps.

As you can see in the screenshot above, you can just refer to several cells and combine them with the &-sign.

How to combine 2 columns in excel with a space

That’s it.

Method 2: CONCAT function

The CONCAT function has been introduced to Excel with the version 2016. It’s not available on previous versions of Excel. And that’s already the big

how to join two columns in excel

how to merge two cells in excel without losing data