![combine cells in excel combine cells in excel](https://cdn.ablebits.com/_img-lp18/excel-merge-cells-lp18/cells-into-one-initial.png)
The full formula will look like this: =CONCAT(A3,B3) Type a comma, and then type the address of the next cell that you want to combine with, such as B2.Type the address of the first cell that you want to combine with, such as A2.To combine the data from cells with the CONCAT formula in Excel, follow these steps: Copy / fill down the formula to use it on the entire column, or change the cell references into range references to turn the formula into an array.The full formula will look like this: =CONCATENATE(A5,B5) Type a comma, and then type the address of the next cell that you want to combine with, such as B5.Type the address of the first cell that you want to combine with, such as A5.
![combine cells in excel combine cells in excel](https://www.easyclickacademy.com/wp-content/uploads/2019/06/How-to-Merge-Cells-in-Excel-merge-cells-horizontally-768x432.jpg)