How to Merge Cells in Excel
If you want to merge cells or columns in Excel, you can do it with a simple formula. We’ll show you how it’s done.When working with Excel, you may want to merge the contents of two or more columns. You can do this in just a few steps in Microsoft Excel. We will show you what you have to be aware of.
Merge Cells in Excel
For example, if you want to merge a list of names-listed in a last name column and a first name column-into one column, it’s best to use the ampersand:
- In the cell where you want to get the merged text, enter the formula = A2 & “” & B2 to merge the values in A2 and B2 with a space in between.
- To merge the two cell contents with a comma, use = A2 & “,” & B2. With the command = A2 & B2, both contents are merged directly, which however makes sense in the fewest cases.
- You can merge an entire column by copying the formula down . To do this, drag the upper field into which you entered the formula with the mouse downwards in the lower right corner.
- Of course, you can also merge more than two columns or cells. In this example, we use the command = A2 & “” & B2 & “” & C2.
- Tip: You can also use any other shortcuts, such as “and”. Simply place the desired word or character between the two quotation marks.
Merge Excel columns
To connect the contents of two columns in Microsoft Excel, you must use the so-called & operator:
- In the cell where you want to merge the contents of the other cells, enter the formula “= A1 &” “& B1” to merge the contents of cells A1 and B1.
- Here the space between the “” “is important, otherwise there is no space between the merged contents.
- Alternatively, you can insert a comma instead of a space. To do this, you only need to insert the desired character or word in the formula.
- To merge more than just two columns or cells, you just have to put more cells in the formula: “= A1 &” “& B1 &” “& C1”. You can use this scheme to merge any number of cells or columns.
You have to do this to format long tables
You can format very long tables in the above mentioned way . All you have to do is copy the formula down. To do this, mark the cell with the formula “= A1 &” “& B1” and drag it down with the mouse pointer.
There is also the possibility to connect cells with the option “Connect and center” in the subitem “Alignment”, which can be found under the menu item Start. Here, however, the contents of all the cells that are connected are lost – with the exception of the cell furthest to the left.