Public Sub Delete_rows()
Dim N As Long, i As Long
Application.ScreenUpdating = False
With ActiveSheet
N = .Cells(.Rows.Count, 1).End(xlUp).Row
For i = N To 1 Step -1
If Left(.Cells(i, 1), 4) = "LIST" Then
.Cells(i, 1).Value = WorksheetFunction.Trim(.Cells(i, 1).Value)
Else
.Cells(i, 1).Delete shift:=xlShiftUp
End If
Next
End With
End Sub