how do I delete cells concatenanted w/out loosing combined info
I don't know how to delete cells without loosing info in cells I've
concatenanted. Does anyone know? |
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? |
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? |
All times are GMT +1. The time now is 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com