How Concatenation Works in Excel

How Concatenation Works

If a worksheet includes first names in one column and last names in another column, for example, you can enter a formula in a third column that joins the first name with the last name. Suppose that the first names are located in column B and the last names are located in column C; row 1 is the first row in the list.    

 

The ampersand (&) is the concatenation operator that joins text, numbers, and dates into one long text string.

Try This

1. Select the cell where you want the formula to appear, and type an equal sign (=) to start the formula.  2. Type or click the first cell reference or name in the formula.  3. Type the concatenation operator (&), then type or click the next cell reference or name.