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

  • Thread starter Thread starter LLR
  • Start date Start date
L

LLR

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Merge then delete cells 1
HELP!!!!!!!!! 2
Counting Merged Cells 5
equals merged cells 2
How do I reference a value to consecutive merged cells 1
Horizontal merging of cells 1
Sharing workbooks limitations - Merged Cells 12

Back
Top