Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 06, 05:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 17
Default Deleting cell data without deleting formula

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

--
remove .spoo to reply by email

  #2   Report Post  
Old October 28th 06, 05:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Deleting cell data without deleting formula

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!
================================================== ===


"Tom Hall" wrote in message
...
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

--
remove .spoo to reply by email


  #3   Report Post  
Old October 28th 06, 05:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,118
Default Deleting cell data without deleting formula

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


"Tom Hall" wrote:

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

--
remove .spoo to reply by email

  #4   Report Post  
Old October 28th 06, 07:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Deleting cell data without deleting formula

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
--
Gary's Student


"Tom Hall" wrote:

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

--
remove .spoo to reply by email

  #5   Report Post  
Old October 29th 06, 05:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 17
Default Deleting cell data without deleting formula

On Sat, 28 Oct 2006 11:30:01 -0700, Gary''s Student
wrote:

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

--
remove .spoo to reply by email


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Formula and Data Entry in a Single Cell Josh VM Excel Discussion (Misc queries) 1 October 21st 05 09:31 PM
Any cell containing formula seen as data instead of formula Jeffry61 Excel Worksheet Functions 2 September 23rd 05 02:04 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017