removing incomplete entries in Excel sheet

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-
 
G

Gord Dibben

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
 
K

-keevill-

The data is in separate cells and your way worked beautifully !
Many thanks again.
 
Top