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, F5SpecialBlanksOK

EditDeleteEntire Row.

If all in one cell, much more difficult.

Show us a few rows as a sample.


Gord Dibben MS Excel MVP


On Thu, 12 Jun 2008 09:50:53 +0700, "-keevill-" wrote:

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-