View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael A Michael A is offline
external usenet poster
 
Posts: 48
Default Copying certain lines from a text file

Hi, I have a text file with 30,000 lines. I need to figure out a way to copy
only the lines that start with [SC] and the surrounding lines (1 above, 1
below) to my excel sheet. I can import the whole sheet into excel, but I cant
figure out how to sort it and still keep the 3 lines I need together.. Any
help pls? Thank you!