how do I delete cells concatenanted w/out loosing combined info

  • Thread starter Thread starter mngirlintx
  • Start date Start date
M

mngirlintx

I don't know how to delete cells without loosing info in cells I've
concatenanted. Does anyone know?
 
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
 
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
 
Back
Top