can anyone help me with this??

[Glen in Orlando]

hello all.
I am hoping that someone in this vast pool of Excel knowledge might be able
to help me with this problem.

This list shown below in blue....

10/04/06 10/05/06 108 757 ANC-NRT 1600 2325 ..WR...
07/06/06 09/29/06 108 757 ANC-NRT 1600 2325 ...RF..
07/01/06 10/21/06 108 757 ANC-NRT 1700 0025 .....S.

08/22/06 @ 08:00 UPS COMPASS DATABASE Page
2
BREPORT4 CITY PAIR
JUMPSCHD
Operation
Start End Flt No A/C Orig-Dest Z-Out Z-In MTWRFSS
-------------------------------------------------------------------------------
08/08/06 09/29/06 71 M1F ANC-ONT 0005 0455 .TWRF..
10/04/06 10/06/06 71 M1F ANC-ONT 0005 0455 ..WRF..
08/12/06 09/30/06 71 M1F ANC-ONT 0005 0455 .....S.
10/03/06 10/03/06 71 M1F ANC-ONT 0035 0525 .T.....

is just a small part of a very, very long list on my company's website. I
take this list and
convert it to a mobileDB file for use on palm pilot PDA's.
This list is over a hundred pages long and each page starts with the header
you see above in Red.
After copying the entire list from the website, I usually pasted it into
excel, and then have to MANUALLY
scroll thru this massive list to remove the header, and collapse the list.
It is a royal pain in the butt.
After that is done, I use the text to columns command, save it as a CSV
file, and export it to MobileDB-PC

Here's my question. Is there anyway to automate the process of finding
these headers, deleting them, and collapsing
the list so that it is one continuous result without any of these headers
remaining??

thanks for any help you can offer

Glen

 

[Pete_UK]

A simple way is to set up a filter. From your snippet of data I would
suggest the 5th column, using a Custom filter for "Does not contain"
then ANC- or "Does not begin with" and ANC-. Alternatively, a custom
filter on the 8th column for "Does not contain" a full-stop. Or you
could try the 3rd column, looking for blanks OR "Flt No" (I'm not sure
if your row of hyphens is all in column A).

Glen,

Select the appropriate column identifier to highlight the complete
column, then Data | Filter | Autofilter (check) to apply the filter to
only one column, all the way down. Then choose the appropriate filter
for that column.

The rows displayed are the ones you want to get rid of, although you
might want to keep the first headers. Click on the row identifier of
the first row you want to delete in order to highlight it, then hold
the SHIFT key down and press END once followed by the Down-Arrow, then
release SHIFT. This will have highlighted all the rows, then Edit |
Delete Row. From the filter pull-down select All, and then you will
have your data all bunched up. You might want to do Data | Filter |
Autofilter (uncheck) to remove the filter entirely.

A much simpler operation than deleting them manually.

Hope this helps.

Pete

 

[Glen in Orlando]

thankyou Pete...
I will give it a try...

glen in orlando