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

[-keevill-]

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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-

[Gord Dibben]

Good to hear.

Gord

On Thu, 12 Jun 2008 11:22:52 +0700, "-keevill-" wrote:

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
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-