Exel combining

Occasional Visitor



When I combine two cells (for example A1&" "&B2) and then want to delete the original cells, then how do i do it without excel deleting the new partition, too?

1 Reply



Select the cell(s) with the combination you want to keep, select Copy from the menu, then Paste Special,



and select "Values"



and paste right on top of the same cells. This gets rid of the formula, so you can delete the original.