Deleting rows containing common data

I have an Excel 2000 spreadsheet with 30,000 rows. The rows look like this:

007-007
68-4611
68-4682
total
007-007
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
28-4831
68-2454
68-4682
total
007-007
68-4682
total
007-007
68-4682
total


How do I delete the rows containing "total"

One way:

1. Select the range and apply an AutoFilter (Data > Filter
> AutoFilter)
2. On the drop-down list, select "Total".
3. Select the range again if needed.
5. Press F5 > Special and click "Visible Cells Only."
6. Remove the filter the same way it was applied.
7. Press <Ctrl><->.
8. Click on "Entire row".

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have an Excel 2000 spreadsheet with 30,000 rows. The
rows look like this:
>
>007-007
>68-4611
>68-4682
>total
>007-007
>total
>007-007
>28-4831
>68-2454
>68-4682
>total
>007-007
>28-4831
>68-2454
>68-4682
>total
>007-007
>28-4831
>68-2454
>68-4682
>total
>007-007
>68-4682
>total
>007-007
>68-4682
>total
>
>
>How do I delete the rows containing "total"
>
>.
>