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

M

mngirlintx

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

FSt1

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
 
S

Shane Devenshire

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
 

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

Concatenate cells with line breaks in them 4
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
How specify number format of cell value in concatenate function? 1
Generating Functions with "Concatenate" 2
*Issue* Concatenate dates in a large range of cells in a row. 5
Concatenate By Selection 2
combining columns and using concatenate 5
Concatenate question 4

Top