View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin R Martin R is offline
external usenet poster
 
Posts: 1
Default is there a way to delete alternate rows in excel

I have a table generated by a datalog program running for about 7 days.
Unfortunately the log interval was inadvertantly set to 5 instead of 30
seconds, & the data now extends over 2 text files, each of about 65000 lines,
close to the Excel 2003 limit. Can anyone advise a simple way to delete
alternate rows, either in the text file or in the excel file?