View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Remove headers from text file

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.
--
Kevin Backmann


"Hilton" wrote:

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