how do I merge cells into one then delete the original cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LLR - 07 Mar 2008 13:36 GMT

I'm trying to merge Name cells into one - got it done, but then I need to
delete the cells I merged - keep getting the reference error, as I delete the
cells that are in the formula

Reply to this Message

Pete_UK - 07 Mar 2008 14:27 GMT

Highlight the cells where the formula is and then fix the values by
clicking <copy>, then Edit | Paste Special | Values (check) | OK then
<Esc>.

You can now safely delete the original columns of data.

Hope this helps.

Pete

> I'm trying to merge Name cells into one - got it done, but then I need to
> delete the cells I merged - keep getting the reference error, as I delete the
> cells that are in the formula

Reply to this Message

Gord Dibben - 07 Mar 2008 22:59 GMT

And don't call them "merged cells".

You have "combined" the contents of two cells into one.

That is not "merging" which is combining the contents of one cell into two or
more cells.

Gord Dibben MS Excel MVP

>I'm trying to merge Name cells into one - got it done, but then I need to
>delete the cells I merged - keep getting the reference error, as I delete the
>cells that are in the formula

Reply to this Message