Paste the copied value in the top-left cell of the range you want to merge (A2).
You can now unmerge the cells.Ĭopy the cell with the CONCATENATE formula (D2). When you click an item in the list, Excel selects the merged cell in your worksheet.
Click the Merge Cells check box until it is clear.