Sub test()
Dim rng As Range, irw&, w&, arr
irw = Cells(Rows.Count, 1).End(xlUp).Row
For w = 1 To irw
If Cells(w, 1) = "" Or InStr(Cells(w, 1), Chr(32)) Then
If rng Is Nothing Then Set rng = Rows(w) Else Set rng = Union(rng, Rows(w))
End If
Next w
If Not rng Is Nothing Then rng.Delete
End Sub