delete garbage from worksheet

  • Thread starter Thread starter mkk
  • Start date Start date
M

mkk

Hi,

I got a large feed from our mainframe and am trying to clean it up.
just want to keep rows where the number in column A is between 8000 an
10,000. Is there any way to delete the rest?

Thank
 
One way would be to simply sort on Col A and then delete all rows above and
below your criteria. Anything can be automated, but for one offs, it's usually
just as quick to do it manually.
 
Back
Top