Oct 07 2022 08:22 AM
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?
Oct 07 2022 09:09 AM
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.