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

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

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

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

On Mar 7, 1:36*pm, LLR wrote:
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

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

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

On Fri, 7 Mar 2008 05:36:07 -0800, LLR wrote:

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