View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how do I delete cells concatenanted w/out loosing combined info

hi
if i understand you correctly, you are talking about a concatenation formula
that looses it data when you delete the source cell data.
copy the concatenation formula and paste as values. this turns the formula
into hard data. the other cells are no longer needed.

Regards
FSt1

"mngirlintx" wrote:

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