If you have zero length strings in cells that are returned by formulae, then
to remove them enter and run:

Sub clear_nothing()
For Each r In ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormu las)
If Len(r.Value) = 0 Then
r.Clear
End If
Next
End Sub

--
Gary''s Student
gsnu200707


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

??