Thanks, but I can't see that makes a difference.

An example would be if you have a genuinly empty range of cells in Column B,
and you enter a formula in B1 something like

=IF(A1=10,"10+","")

you'll get

Col A = Col B
10 = 10+
(blank) = blank
5 = blank
15 = 10+

but the blanks in column B are actually zero length strings. If you
copy&paste special, "values only" on column B, and sort A-Z, the "empty"
cells will appear the top, whereas a genuinly empty cell wouldn't.

If you then go Edit Clear All on those cells and re-apply the sort, they
appear at the bottom.

How can either get rid of those zero-length's or write formulas that produce
a genuine null.?


"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.

??