How to concatenate two or more cells in Excel?

To concatenate (combine) the contents of two cells into one cell in Excel, you can use the CONCATENATE function or the ampersand (&) operator. Here are the steps using either method:

Using CONCATENATE function:

1. Select the cell where you want to combine the contents.
2. In the formula bar, type “=CONCATENATE(” (without quotes).
3. Click on the first cell you want to combine.
4. Type a comma (,) to separate the two cell references.
5. Click on the second cell you want to combine.
6. Type “)” to close the function.
7. Press Enter to complete the formula.

For example, if you want to combine the contents of cells A1 and B1 into cell C1, the formula would be: =CONCATENATE(A1, B1)

Using the ampersand (&) operator:

1. Select the cell where you want to combine the contents.
2. In the formula bar, type “=” (without quotes).
3. Click on the first cell you want to combine.
4. Type “&” to concatenate.
5. Click on the second cell you want to combine.
6. Press Enter to complete the formula.

For example, if you want to combine the contents of cells A1 and B1 into cell C1, the formula would be: =A1&B1

After entering the formula, the combined text from the two cells will appear in the selected cell. You can then copy the formula down to apply it to other cells if needed.