removing incomplete entries in Excel sheet

  • Thread starter Thread starter -keevill-
  • Start date Start date
K

-keevill-

I have an excel sheet containing rows of names and addresses .
How can I filter and remove the entries which are incomplete such as ones
with a forename missing ?
Thanks in advance !
-keevill-
 
Are the names and addresses in separate cells or all in one cell?

If the former, are the cells with the missing data blank?

If so, F5>Special>Blanks>OK

Edit>Delete>Entire Row.

If all in one cell, much more difficult.

Show us a few rows as a sample.


Gord Dibben MS Excel MVP
 
Back
Top