How to concatenate two or more cells in Excel?

Picture of Amitpal Singh
Amitpal Singh
July 4, 2023

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.

Share this post:

How to Attribute?

Lorem ipsum is typically a corrupted version of De finibus bonorum et malorum, a 1st-century BC text by the Roman statesman and philosopher Cicero.
for Example: Website, Social Media, Blogs, ebooks , newsletter, etc.
Lorem ipsum is typically a corrupted version of De finibus bonorum et malorum, a 1st-century BC text by the Roman statesman and philosopher Cicero.
Copied!

Got a Question? Check out our FAQ Section.

Your action, our appreciation

It encourage us to give you more valuable content on website.