View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
amaries amaries is offline
external usenet poster
 
Posts: 21
Default how do I remove page headings from an imported text file

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?