Delete Unwanted Data

I need to import a text file into excel and do the following :

This text file is broken into “Information on object # 1 through #35. In each of these objects I would like to extract the NAME row and SEGMENT LENGTH row and delete the rest. CAN ANY BODY HELP.

Some times these files are 1000's of objects so I need to automate it some how.

Thanks in advance for your help!