Combining Values of Cells in MS Excel

When you have two or more cells with values that you need to merge in one cell, there are several ways to do this in MS Excel.

Method 1: Using CONCATENATE

The CONCATENATE function is used by identifying the cells which will be combined as one.  It is simply done as seen in the image below.

You can also add other characters in the string by enclosing them inside quotation marks.  In the example below, a space is added to separate the first name and the last name.

Method 2: Using the ampersand

The ampersand (&) can also be used to combine values of cells.  The ampersand is used like an operator, acting as if a glue that combines the cells or values (inside quotation marks as well.)  The example below demonstrates how to use ampersand to combine texts.

There are new functions in Excel 2019 that can also combine texts.  Read about them here.