![merging cells in excel without losing data merging cells in excel without losing data](https://www.exceldemy.com/wp-content/uploads/2018/05/merged-cells.png)
Else, it will not give you the desired result. Click Merge and Center or Merge Cells, depending on whether you want the merged text to be centered or not. On the Home tab, in the Editing group, click Fill > Justify. Make the column wide enough to fit the contents of all cells. Select all the cells you want to combine.
![merging cells in excel without losing data merging cells in excel without losing data](https://cdn.extendoffice.com/images/stories/doc-excel/merge-cells/doc-merge-columns-into-one-formula-5.png)
Merging cells in excel without losing data how to#
However, before using the option, you’ll need to first increase the width of the column. We have some data in a few cells and we like to merge the cell contents in to one big cell. How to merge cells in Excel without losing data. Inside the Home tab (in your Excel worksheet) look for the Fill option. If you are not comfortable with VBA programming or macros, then you can use Excel’s Justify feature. Merge Cells using Excel’s Justify Feature How to merge cells in Excel without losing data. I’ll loop through the Selection object to extract each cells value and concatenate the texts and numbers (if any) and store it in a variable.įinally, I’ll use the Selection object again, to assign the extracted values to a cell (Cells(1) or the first cell in the first row), align it according to my requirement and merge it.
![merging cells in excel without losing data merging cells in excel without losing data](https://cdn.corporatefinanceinstitute.com/assets/merge-cells-step-2.png)
The Selection object represents the selected area in the worksheet. In the macro, I am using the Selection object as a Range. First, select or highlight the rows that you wish to merge and then hit the button. Now here's how you will merge all the cells value.