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. 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. The constructs used by the statement that finds the last row with data in the worksheet are the Worksheet.Cells property, the Range.Find method, and the Range.Row property. 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. How to merge cells in Excel without losing data. myLastRow is set to the number of the last row with data in the worksheet named Merge Cells Based on Cell Value.
0 Comments
Leave a Reply. |