Excel: Merge cells and columns
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.
Merge cells and columns in Excel
For example, if you want to combine a list of names - listed in a column for the last name and one for the first name - into a column, it is best to use the ampersand:
- Enter the formula = A2 & "" & B2 in the cell where you want to receive the merged text 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, but this rarely makes sense.
- You can merge an entire column this way by copying the formula down. To do this, drag the upper field in which you entered the formula down with the mouse at 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". Just put the word or character you want between the two quotation marks.
Do not confuse merging cells with merging cells.