Re: Clear data but leave formulas

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Jeff Granger" <jeff.granger@xxxxxxxxxxx>
Date: Mon, 2 Jul 2007 11:00:14 +0100

Thanks Niek

that did the trick!

"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message
news:%23hENyvIvHHA.4404@xxxxxxxxxxxxxxxxxxxxxxx

Hi Jeff,

Edit>Go To>Special. Check Constants and Numbers and/or Text
Edit>Clear>Contents

Make sure you have a copy of the file available!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jeff Granger" <jeff.granger@xxxxxxxxxxx> wrote in message
news:YsWdnV-Z_frGKBXbRVnyhwA@xxxxxxxxx
| Starting a new financial year I want to clear all last year's data from
a
| table, but leave the formulas and formatting.
|
| Any suggestions?
|
| Jeff
|
|

References:
- Clear data but leave formulas
  - From: Jeff Granger
- Re: Clear data but leave formulas
  - From: Niek Otten

Prev by Date: Re: Clear data but leave formulas
Next by Date: Re: Glaring Excel calc bug.
Previous by thread: Re: Clear data but leave formulas
Next by thread: Converting excel file to text
Index(es):
- Date
- Thread

Relevant Pages

Re: Clear data but leave formulas
... Kind regards, ... Microsoft MVP - Excel ...
(microsoft.public.excel)
Re: Remove characters from string
... Kind regards, ... Microsoft MVP - Excel ... | there expaining regular expressions unless you meant I should search for it. ... |> | the string I remove extraneous characters. ...
(microsoft.public.excel.programming)
Re: Can you write your own NETWORKDAYS function?
... and everyone elses help / suggestions. ... Kind regards, ... Microsoft MVP - Excel ...
(microsoft.public.excel.worksheet.functions)
Re: Can you write your own NETWORKDAYS function?
... Kind regards, ... Microsoft MVP - Excel ... |> Hi Duncs, ...
(microsoft.public.excel.worksheet.functions)
Re: Extreme calculations
... Kind regards, ... Microsoft MVP - Excel ... |> Do you have some sort of key to that thread? ...
(microsoft.public.excel.programming)