Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry, I mis read the origional question
If you use =IF(A34=10,"10+") you then get 'false' rather than a blank cell and then these will be sorted to the bottom of the list if that is any help? - John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Matt D Francis" wrote: Can't see how that would work? An example would be if I use a formula like IF(A110,"Over","") The "" doesn't leave the cell empty, it leaves a zero-length string that appears before text if the column is sorted. How do I either write formulas that return a true null, or get rid of the zero-length strings? Edit Clear All works on a cell range where the but I want to be able to cover the whole spreadsheet in one go. ?? "john" wrote: Try tools/options/view tab/remove the tick from zero values -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Matt D Francis" wrote: Hi, I want a quick way of clearing all zero-length strings from a spreadsheet I tried using Find & Replace Find: "" Replace: (left blank) But it put zeroes in instead of actuall deleting all contents. ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
clear all zero-length strings from spreadsheet? | Excel Discussion (Misc queries) | |||
clear all zero-length strings from spreadsheet? | Excel Discussion (Misc queries) | |||
How do I clear contents from a spreadsheet but not the formulas | Excel Discussion (Misc queries) | |||
Using control to clear spreadsheet | Excel Discussion (Misc queries) | |||
How do I export an Excel spreadsheet with fixed length rows? | Excel Discussion (Misc queries) |