LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove text qualifiers from imported data? Gail Baker Excel Discussion (Misc queries) 0 October 26th 06 05:51 PM
Single text file imported to multiple worksheets Lynn Bales Excel Worksheet Functions 2 September 21st 06 10:42 PM
imported doc from pdf file, want to seperate text & date in cells Christian Excel Discussion (Misc queries) 2 February 2nd 06 08:13 PM
can I display the file name of the imported text file in another c John-G Excel Discussion (Misc queries) 0 May 13th 05 03:38 PM
problem working with time data imported from text file afaqm Excel Worksheet Functions 1 February 24th 05 08:02 AM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"