Thread: how do I delete cells concatenanted w/out loosing combined info
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default how do I delete cells concatenanted w/out loosing combined info
Convert the formula to a value:

Highlight the formula on the Formula Bar and press F9, Enter.

Or use Copy, then Edit, Paste Special, Values

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"mngirlintx" wrote:

I don't know how to delete cells without loosing info in cells I've
concatenanted. Does anyone know?
Reply With QuoteReply With Quote