Deleting cell data without deleting formula

[Tom Hall]

In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

 

[RagDyeR]

A cell cannot contain data and a formula.

The formula is the actual cell contents, and what the formula is constructed
to return is what the cell displays.

If the formula depends on the contents of other cells (=A1+B1),
you could remove the data in those cells, unless ... of course ... if they
*also* contain other formulas.

If the formula is self-contained (=100+25),
then there is no way to remove the data without removing the formula.

SO ... exactly what are you looking to accomplish?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


In Excel 2003, is it possible to delete the contents of a cell without also
deleting the formula?j

It seems that "contents" include data and formula, but I can't seem to find
a way of separating one from the other.


Tom

 

[Guest]

Can you clarify how you differentiate cell formulas from cell data when
referring to cell contents? An example would probably help.


***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

If you have a worksheet with a mixture of data and formulae and want to clear
out the data, but leave the formulae alone then:

Edit > Go To > Special... and click Constants and then OK
this selects the data, but not the formulae
Edit > Clear > All
clears out the data

 

[Tom Hall]

If you have a worksheet with a mixture of data and formulae and want to clear
out the data, but leave the formulae alone then:

Edit > Go To > Special... and click Constants and then OK
this selects the data, but not the formulae
Edit > Clear > All
clears out the data

Thanks!

The others who replied pointed out a flaw in my thinking, but you've
actually given me what I was looking for.

Thanks again!


Tom