address spreadsheet

ggaylwen · #1 09-07-2008, 09:16 PM

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

Quote:

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 ?

stevekirk · #2 09-07-2008, 10:46 PM

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

ggaylwen · #3 09-08-2008, 12:25 AM

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.

martindwilson · #4 09-08-2008, 03:38 PM

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
spreadsheet for multiple users	evanzo	Excel Programming	5	10-30-2008 12:04 AM
Auto-retrieve and manage data from another spreadsheet	techissue2008	Excel Programming	3	06-16-2008 01:17 AM
Updating distributed spreadsheet online	KnuxAran	Excel General	0	04-28-2008 11:30 PM
Need help: Simple spreadsheet "broke"	iCamp	Excel Miscellaneous	4	01-11-2007 12:47 PM
Extracting the class C address from an IP address via a formula in Excel	floep	Excel Programming	3	10-23-2006 05:05 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)