removing incomplete entries in Excel sheet

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

 

[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

 

[-keevill-]

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

 

[Gord Dibben]

Good to hear.

Gord

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