Thread: Remove Headers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
 
Posts: 287
Default Remove Headers

Hilton,

Can you sort your whole file by the field starting with ! and then delete
out all the repeating headers except for one?

"Hilton" wrote:

I have a 125 files combined into 1 file. As a result the combined file has
headers all over. The data line starts with a "*" and the headers start with
a "!". How do I step through the file and delete all the headers except the
1st one? Please help.

Thanks
Hilton