get-digital-help.com

Deleting empty cells in a cell range is easy.

1. Select the cell range
   
2. Press function key F5
   
3. Click "Special..." button
   
4. Double click on "Blanks", see picture above.
   
5. Right click on a selected cell and click "Delete"

Formulas evaluating to an empty text string

What about formulas evaluating to an empty text string, like this formula:

The above steps won´t work unless you change the formula to this:

The formula evaluates to an error:

It is possible to select cells evaluating to an error:

1. 1. Select the cell range.
   2. Press function key F5
   3. Click "Special..." button
      
   4. Select Formulas and Errors, see picture above.

1. Right click on a selected cell and click "Delete"

Macro

If you don´t want to use the above technique or perhaps can´t, the following macro deletes formulas evaluating to an empty text string:

Sub DeleteBlankRows()
For i = Selection.Cells.Count To 1 Step -1
If Len(Selection.Cells(i)) = 0 Then Selection.Cells(i).Delete xlUp
Next i
End Sub

How to use macro

1. Select a cell range
2. Press Alt + F8 to open the macro dialog box
3. Select macro "DeleteBlankRows"
4. Click Run

This macro deletes the entire row if cell formula evaluates to an empty text string:

Sub DeleteBlankRows()
For i = Selection.Cells.Count To 1 Step -1
If Len(Selection.Cells(i)) = 0 Then Selection.Cells(i).EntireRow.Delete xlUp
Next i
End Sub

It is not possible to undo a macro so make sure you have made a backup!

Download excel *.xlsm file

Delete formulas evaluating to an empty string.xlsm