importing and filtering data

  • Thread starter Thread starter Phillip Harrison
  • Start date Start date
P

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
 
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.
 
Back
Top