Thread: how do I merge cells into one then delete the original cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default 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

Reply With QuoteReply With Quote