address spreadsheet

Hi there
I have an address spreadsheet with 200 addresses on it for a mail merge. About 30 addresses are incomplete. Is there a way I can separate these entries quickly to a new document for working on later? Each part of the address is in its own column. I am a new excel user.
I found this entry in another forum but do not understand where to put the function if this is what I should be doing.
Thanks, A

Re: removing incomplete entries in Excel sheet by Gord
Gord
Wed Jun 11 22:41:56 CDT 2008

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


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 ?

hi ggaylwen,

welcome to the forum,
may i suggets you attach a sample of what you have and how you want it to look like. that way it would be easier to understand what you need

steve

Hi, I'm attaching a simple pdf version - its a basic elementary spreadsheet. Some of the addresses are not complete - I simply want to extract them from this sheet and dump them in a new one. The original has over 300 addresses and I have to extract about thirty.

using auto filter then filtering each col on non blanks will give you a usable list which you could copy elsewhere for use (copy visible cells only). not quite the way around you asked for tho