How to Combine Cells in Excel
Jun 16, 2020 ยท 2 minute read
There are different ways for combining the cells, here we are going to explaine some of them.
How to Combine Cells in Excel by Merging Cells.
If you have a group of cells next to each other and only one of them has content and the rest are empty, you can use this method;
-
Select all cells.
-
Click the Home tab.
-
Click Merge & Center.
How to Combine Cells in Excel by Formula;
If you have a group of cells and each cell or some of them have content and you want to combine them to each other and keep the content of them, you can use these methods.
First Method;
1- In the cell which you want to combine the content of cells writes this Formula.
=C3&" “&D3&” “&E3
-
Here C3, D3, E3 are the address of the cells.
-
we place " " in the formula because we want to have space between the content of the different cells,
If you want to place - between the content of the cells, you can place “-” in the formula.
2- Specify this formula to other cells of the column too.
Second Method;
1- In the cell which you want to combine the content of cells writes this Formula.
=Concatenate(C3,D3,E3).
- Here C3, D3, E3 are the address of the cells.
You can see the content of the cells were placed near each other without any space.
Third Method;
1- In the cell which you want to combine the content of cells writes this Formula.
=Concatenate(C3,” “,D3,” “,E3).
-
Here C3, D3, E3 are the address of the cells.
-
we place " " in the formula because we want to have space between the content of the different cells,
If you want to place - between the content of the cells, you can place “-” in the formula.
2- Specify this formula to other cells of the column too.
Forth Method;
1- Click on the Formula tab.
2- Click on the Insert Function.
3- In order to find this command easier, choose the Text category.
4- Find CONCAT command and press Ok.
5- Write the name of cells which you want to combine them and because we want to have space between the content of cells we placed " " in the Text2 and Text4 part in the Function Arguments dialogue.
6- Specify this formula to other cells of the column too.
