how to adjust merge cells in excel without losing data

Type 1 combined data with the desired format in the first row. Please see the video tutorial below, for step by step:įor solutions with other functions, please read the following article: Solution #2, Using Flash Fill Menuįlash Fill is no formula solution. You must convert the formula to the text, do this by doing a Copy (CTRL+C) – Paste Special (CTRL+ALT+V) – Values. This error occurs because the “Full Name” column contains a formula. The next step is to delete the “First Name”, “Middle Name” and “Last Name” columns.Īn error appeared, the full name data that was already available properly disappeared instead with #REF! Error. Regardless of the number of cells to be merged, TEXTJOIN function requires only the range address, no need to type all the cell addresses to be merged.

The excel TEXTJOIN function is the best function provided by Excel to merge multiple cells without losing data. For more details, read the explanation below. The solution is to use a formula or other solution that is easier and faster, with no formula losing no data. To merge two cells or more without losing data, you cannot use the “Merge Cells” command because Excel only keeps the data in the upper-left cell, you lose data in another cell. With this, you can join row by row, column by column, or merge data from the selected cell into one without any loss. And with the merge cells add-in you can merge data from many cells by using any separator you like (for example carriage return or line break). Just make use of the third party merge cells add-in for Excel. The craft of Excel feels like it dates back to the dawn of computing, but still there are plenty of things you may not know how to do with it. When the two cells are merged, only the data contained in the top left one is retained. To merge the cells, use the «Alignment» tool, which can be found on the main tab.

See screenshot: (1) Select Combine columns under To combine selected cells according to following options (2) Specify a separator for the combined data, here I select the Space option (3) Specify the cell you want to place your combined result (4) Specify how you want to deal with the combined.

Merging cells in Excel step by step: Let's take a small table with several rows and columns. The information appears in the center of the merged cell. The result will be one cell occupying two rows or columns simultaneously.

How to merge cells in Excel without losing data? Neighboring cells can be merged in vertical or horizontal direction.

How to adjust merge cells in excel without losing data