Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I remove text qualifiers from imported data? | Excel Discussion (Misc queries) | |||
Single text file imported to multiple worksheets | Excel Worksheet Functions | |||
imported doc from pdf file, want to seperate text & date in cells | Excel Discussion (Misc queries) | |||
can I display the file name of the imported text file in another c | Excel Discussion (Misc queries) | |||
problem working with time data imported from text file | Excel Worksheet Functions |