| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
| Some lines of text in Excel field do not wrap text. Please help. | Excel Discussion (Misc queries) | |||
| Excel, how copy subtotals without copying all lines inbetween? | Excel Discussion (Misc queries) | |||
| Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions | |||
Threaded Mode
