Yes, you can. Let me write some vba code when I come back in a few hours.

用iserror函数就好

试试下面的代码把#div/0!换成空白.

Sub Change_Formula()
    Dim sTemp1 As String
    Dim sTemp2 As String
    Dim iTemp As Integer
    Dim i As Integer
    Dim j As Integer
    Dim iRow As Integer
    Dim iCol As Integer
   
    iRow = ActiveSheet.UsedRange.Rows.Count
    iCol = ActiveSheet.UsedRange.Columns.Count

    For i = 1 To iRow
        For j = 1 To iCol
            If Cells(i, j).HasFormula Then
                sTemp1 = Cells(i, j).Formula
                iTemp = Len(sTemp1)
                sTemp2 = Right(sTemp1, iTemp - 1)
                Cells(i, j).Formula = "=IF(ISERROR(" & sTemp2 & ")," & Chr(34) & Chr(34) & "," & sTemp2 & ")"
            End If
        Next j
    Next i
End Sub

筛选一下就可以全部删除

筛选排序以后直接删掉。