Remove Unprintable Non-Blank Cells Having Zero Length Contents

[Excel Fox]

I understand this may be a memory intensive code loop, but it worked for me with your sample file

Sub ClearNonLenCells()

    Dim C As Range
    For Each C In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
        If Len(C) = 0 Then
            C.ClearContents
        End If
    Next C
    
End Sub