how do I remove page headings from an imported text file

[amaries]

I have a text file that has page headings on every page, breaks aprox every
20 lines. The page heading is spread across 8 columns and is three rows. Is
there any easier way than going through and highlighting the three rows and
deleting? This will take a very long time as there were about 500 pages(x 3
unneeded rows). Otherwise I can do same thing in the text file then do
import but still same amount of work. Since there is a find and replace
option is there a find and delete function? The only difference in each set
of unneeded row is the old page number otherwise everything else is repeated
report/page/column titles. Any ideas?

 

[Dave O]

report/page/column titles.  Any ideas?

Here's one idea:
~ Make a backup copy of your file to avoid losing data!
~ Insert a new column A and starting at the top of your file, number
each row. (You can do this by typing 1 in cell A1 and the putting the
formula =A1+1 in cell A2; copy that down for all 500 pages; then
highlight column A, copy, and "paste special as values" back over
itself so what remains is the numeric entries only, no formulas.)
~ Sort all the rows in such a way as to group all the header rows
together- do this by choosing a column that is unique to the header
rows. For instance: choose a column that contains only numeric data,
and sort it alphabetically: all the text rows- the headers- will be
grouped together, and all the data will be separate.
~ When all the header rows are grouped, delete those rows.
~ Sort all the rows on column A, the row numbers you added, to get the
data back to its original order
~ Delete column A

Dave O
Eschew obfuscation