#Excel merge multiple cells at once how to
#Excel merge multiple cells at once for mac

The new data combination should appear in the cell. Once you have completed the formula, press Get into on your keyboard to activate it. You must write it using the same syntax as above: =CONCATENATE(Cell1, “Separator”, Cell2, “Separator”, Cell 3…etc.) You can use this same formula to combine data from multiple columns. In this example, the space between the quotes is the separator, but you can use any other separator you like.įor example, if there is a comma between the quotes =CONCATENATE(A2,”,”B2)the data in cell A will be separated from the data in cell B by a comma. This function tells Excel that you want to merge the data in cell A2 with the data in cell B2, with a space (” “) between them. Select the first cell below the new column header (C2 in this example) enter the following in the formula bar: If your other columns have headers, give the new column a header name. To insert a new column, right-click a column to the right of where you want the new column to appear and select Insert from the menu that appears. In the Excel worksheet where you want to combine two columns of data, please insert a new column near by first this is where your merged data will go. Instead, you will use the CONCATENATE formula to combine those data. If you try to merge the data from two columns into a single column, the merge command will not work. If you want to merge two empty columns in Excel, it is quite easy to do it with the Merge option, but if those columns contain data, you will lose all the data except the one in the top left cell.

#Excel merge multiple cells at once how to

How to combine columns in Excel without losing data The instructions in this article should apply to all of those versions.

#Excel merge multiple cells at once for mac

This feature, according to Microsoft, works for Excel for Microsoft 365 (Windows and Mac), Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2016 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel for Mac 2011, and Excel Starter 2010. This article describes how to merge two columns of data in Excel into a single column without losing that data. Once merged, you must change the merged data to values using copy and paste in order to delete or change the original data.Once you have created the CONCATENATE formula in the first cell, drag the fill handle to duplicate the formula for the remaining cells.Using the concatenation formula in Microsoft Excel, you can combine two or more data columns into one without losing any data.2 How to combine columns in Excel without losing data.1 Combine columns without losing your data.