View Single Post
  #4   Report Post  
Old July 31st 15, 03:16 PM posted to microsoft.public.excel.worksheet.functions
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2015
Posts: 1
Default how do I delete data in a cell without deleting formula?

On Sunday, April 20, 2008 at 11:07:25 PM UTC+1, David Biddulph wrote:
A cell contains either formula or data. It can't contain both.
David Biddulph

"tripy" wrote in message
after adding data to a formulatted cell on a worksheet, i save as, and
use the previous worksheet and delete data to start another worksheet.
doing this I also delete the formulas, which I don't want to do- go to

That is rubbish David