I want to reuse all the data from my health record sheets from 2004, just
creating new sheets for 2005.
How can I remove the text without deleting the formulas too.
Thanks coco
I want to reuse all the data from my health record sheets from 2004, just
creating new sheets for 2005.
How can I remove the text without deleting the formulas too.
Thanks coco
Hi
Goto the Menu: Edit/Go To/ select Special
In Special select Constants and keep Text checked. Uncheck the other 3.
Click OK
Now all your Text should be marked - make sure if you are uncertain!
You can now delete all Text by just pressing Delete.
The same can also be done manually by holding down Ctrl and click on every
thext you want to delete, and then press Delete.
If something goes wrong, hold down Ctrl and press Z to undo.
Ola
Hi Jerome
1. Select one cell or the entire range of cells you are interested in
removing constants from.
2. Select F5 from your keyboard and select the "Special" button.
3. Select the "Constants" button in the dialog box and select OK.
4. Select "Edit>Clear>Contents"
--
XL2002
Regards
William
[email protected]
"Jerome" <[email protected]> wrote in message
news:[email protected]...
| I want to reuse all the data from my health record sheets from 2004, just
| creating new sheets for 2005.
| How can I remove the text without deleting the formulas too.
| Thanks coco
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks