Exel combining

Occasional Visitor

Hi!

 

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

@Samwise817 

 

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

mathetes_0-1665158910797.png

 

and select "Values"

mathetes_1-1665158948320.png

 

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