While I have covered an example where I am combining only two cells, you can use the same logic when combining multiple cells Combine Cells Separated with line breaks You can also do the same with the CONCATENATE formula where you need to specify the separator as well within the formula (in double-quotes): = CONCATENATE ( A2, "-", B2 ) In the above formula, I combine three elements, cell A2, the separator (a dash which needs to be in double-quotes) and cell B2. Suppose you have the dataset as shown below and you want to combine the cells in columns A and B with a dash in between.īelow is the formula that will do this: = A2 & "-" & B2 This could be a space character, a comma or a dash.Īgain, this can be done with simple formulas by specifying the separator when you’re combining cells. In many cases, you would want to combine cells but have a separator in between. Combine Cells with Separator (comma/space) The above CONCATENATE formula simply takes the values that you want to combine and gives you the result. You can also use the below CONCATENATE formula to combine the two cells in Google Sheets: = CONCATENATE ( A2, B2 )
![how to merge 2 cells in excel and keep the data how to merge 2 cells in excel and keep the data](https://i.stack.imgur.com/zyQgz.png)
The above formula uses the ampersand operator (&) to combine values in cell A2 and B2. Suppose you have a dataset as shown below and you want to combine columns A and B and get the result in column C.īelow is the formula that will do this: = A2 & B2 Google Sheets has some really simple formulas that you can use to combine cells and columns.
![how to merge 2 cells in excel and keep the data how to merge 2 cells in excel and keep the data](https://appauthority.com/wp-content/uploads/2021/07/excel-merge-cells-5.jpeg)
Combine Cells with Text and Numbers (Or Text and Dates).
Combine Cells Separated with line breaks.Combine Cells with Separator (comma/space).