Remove headers from text file

  • Thread starter Thread starter Hilton
  • Start date Start date
H

Hilton

Hi all,

I have a combined text file made up from 7 individual files. However now I
have 7 headers in my combined file. How do I create a new text file without
the headers? The header line starts with a !.

Thanks
 
Since it's only 7 lines I would open the text file in a text editor (Notepad
for instance) and then click EDIT in the menu and select FIND. Enter the "!"
w/o the quotes and click OK

Delete the first header line and then press F3 to locate and delete the next
occurrence. Repeat until all header line have been removed.
 
Apply Data|Filter|Autofilter (xl2003 menu system) to the column that contains
that indicator.

Then filter by that column to show the rows that contain (or begin with) an
exclamation point.

Delete the visible rows and remove the filter.
 
Back
Top