importing and filtering data

[Phillip Harrison]

Hi there, Im a little stuck with Excel and wondering if
someone could help me please.

I have a .txt file which just has a list of data (to be
more precise the first 10 lines are string and the rest
are lists of numbers). I need to import this into excel
which i can do using the "import wizard", however i then
need to select all the numbers starting with 10000 and
remove all the other numbers in the list. I have no idea
how to do this and any help would be greatly appreciated.

Thanks

 

[Phillip Harrison]

Sorry, i realise i had not been fully explicit, I need to
do those tasks stated below via a macro so that it can be
run against many similar .txt files quickly and easily.