Excel delete only data, not formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1596246%22%20slang%3D%22en-US%22%3EExcel%20delete%20only%20data%2C%20not%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596246%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20delete%20only%20the%20data%20from%20a%20cell%20without%20also%20deleting%20the%20formulas%20in%20that%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1596246%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1596330%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20delete%20only%20data%2C%20not%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596330%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20answer%20is%20provided%20in%20the%20link%20below%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT009097_Clearing_Everything_Except_Formulas.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT009097_Clearing_Everything_Except_Formulas.html%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1596368%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20delete%20only%20data%2C%20not%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596368%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F133144%22%20target%3D%22_blank%22%3E%40david%20oneil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20good%20approach%20to%20a%20solution%20for%20your%20concern%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-503494092%22%20id%3D%22toc-hId-503494092%22%20id%3D%22toc-hId-503494092%22%3E%3CFONT%20size%3D%224%22%3EClearing%20Everything%20Except%20Formulas%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT009097_Clearing_Everything_Except_Formulas.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT009097_Clearing_Everything_Except_Formulas.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1596606%22%20slang%3D%22de-DE%22%3ERe%3A%20Excel%20delete%20only%20data%2C%20not%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596606%22%20slang%3D%22de-DE%22%3EHello%2C%20%3CBR%20%2F%3E%20in%20advance%20when%20I%20researched%20the%20answer%20and%20sent%20it%2C%20there%20was%20still%20no%20answer%20from%20anyone%20on%20the%20chat%20or%20on%20my%20monitor.%20When%20I%20sent%20my%20answer%2C%20I%20saw%20that%20your%20answer%20was%20just%20before%20mine.%20It%20was%20not%20intended%20to%20preempt%20you%20in%20any%20way%20or%20to%20undermine%20your%20response.%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Unfortunately%2C%20this%20happens%20very%20often%20in%20the%20community%20chat%20the%20refresh%20is%20very%20slow.%20What%20causes%20search%20misunderstandings.%20It%20is%20not%20about%20taking%20something%20away%20from%20someone%20else%2C%20I%20am%20simply%20about%20helping%20people%20without%20having%20or%20wanting%20anything%20as%20a%20reward.%20I%20do%20that%20because%20I%20enjoy%20it%20!!%20Nothing%20more%20and%20nothing%20less.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Hello%2C%20%3CBR%20%2F%3E%20in%20advance%20when%20I%20researched%20the%20answer%20and%20sent%20it%2C%20there%20was%20still%20no%20answer%20from%20anyone%20on%20the%20chat%20or%20on%20my%20monitor.%20When%20I%20sent%20my%20answer%2C%20I%20saw%20that%20your%20answer%20was%20just%20before%20mine.%20It%20was%20not%20intended%20to%20preempt%20you%20in%20any%20way%20or%20to%20undermine%20your%20response.%20%3CBR%20%2F%3E%20Unfortunately%2C%20this%20happens%20very%20often%20in%20the%20community%20chat%20the%20refresh%20is%20very%20slow.%20What%20causes%20search%20misunderstandings.%20It%20is%20not%20about%20taking%20something%20away%20from%20someone%20else%2C%20I%20am%20simply%20about%20helping%20people%20without%20having%20or%20wanting%20anything%20as%20a%20reward.%20I%20do%20that%20because%20I%20enjoy%20it%20!!%20Nothing%20more%20and%20nothing%20less.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thank%20you%20in%20advance%20for%20your%20understanding%20%3CBR%20%2F%3E%20I%20wish%20you%20a%20pleasant%20day%20Thank%20you%20in%20advance%20for%20your%20understanding%20I%20wish%20you%20a%20%3CBR%20%2F%3E%20pleasant%20day%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20I%20know%20I%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Visitor

How do I delete only the data from a cell without also deleting the formulas in that cell?

1 Reply
Highlighted