try it
![]()
Sub ert() Dim x, i&, j& With Range("A1", Cells(Rows.Count, 1).End(xlUp)) x = .Value For i = 1 To UBound(x) If Len(x(i, 1)) <= 79 Then If UBound(Split(x(i, 1))) <= 8 Then j = j + 1: x(j, 1) = x(i, 1) End If End If Next i .ClearContents: .Resize(j).Value = x End With End Sub
Bookmarks