| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Info combined from 2 worksheets into a new worksheet | Excel Discussion (Misc queries) | |||
| how do i delete a table without loosing my data? | Excel Discussion (Misc queries) | |||
| Cells loosing there functions | Excel Worksheet Functions | |||
| How do I partially delete info in many cells at once? | New Users to Excel | |||
| Connect two Cells without loosing content | Excel Discussion (Misc queries) | |||
Linear Mode
