How to make 2 cells into 1 cell in Microsoft Excel

Making 2 cells into one cell in Microsoft Excel refers to merging the contents of two adjacent cells into one cell. This can be a helpful technique for improving the readability and organization of data, especially when working with large spreadsheets. Merged cells may affect other formulas or functions in your spreadsheet, so it’s important to double-check your calculations and adjust any affected cells accordingly.

In this tutorial, we will learn how to make 2 cells into one in Microsoft Excel. In Excel, there are multiple methods to make 2 cells or more into one cell i.e the CONCATENATE function, Ampersand Operator, etc.

Currently, we have a data set with two columns i.e. House and Street. We will combine the House Number and Street from both cells into one cell.

Method 1: Using the Concatenate Function 

Step 1 – Select a Blank Cell

  • Select a blank cell where you want to make one cell from two cells.

Step 2 – Place an Equals Sign

  • Place an Equals sign in the blank cell.

Step 3 – Use the CONCATENATE Function

  • The CONCATENATE function is used to merge content from multiple cells.
  • The syntax will be: 

                     CONCATENATE(A2,” “,B2)

  • Where A1 is the address of the first cell to be combined.
  • “ “ is to separate the combined text using space.
  • B2 is the address of the second cell to be combined.

Step 4 – Press the Enter Key 

  • Press the Enter key to make 2 cells into one cell.

Step 5 – Apply the CONCATENATE Function on Each Row

  • Apply the CONCATENATE function on each row using the Autofill feature.

Method 2 : Using the Ampersand Operator

 Step 1 – Select a Blank Cell

  • Select a blank cell where you want to make one cell from two cells.

Step 2 – Place an Equals Sign

  • Place an Equals sign in the blank cell.

Step 3 – Use the Ampersand Operator

  • Use the Ampersand operator.
  • Syntax will be : 

         A2 & “ “ & B2

  • Where A1 is the address of the first cell to be combined.
  • “ “ is to separate the combined text using space.
  • B2 is the address of the second cell to be combined.

Step 4 – Press the Enter Key 

  • Press the Enter key to make 2 cells into one cell.

Step 5 – Apply the Ampersand Operator on Each Row

  • Apply the Ampersand Operator on each row using the Autofill feature.

Method 3: Using the Flash Fill to Make 2 Cells into 1 Cell

Step 1 – Make the First 2 cells into 1 Manually

  • Make the First 2 cells into 1 cell manually by entering the text in another cell.

Step 2 – Press CTRL + E 

  • Press CTRL + E shortcut keys to use the Flash fill feature.
  • This will instantly make all the pairs of 2 cells into 1 cell.