Delete Rows

[RMT]

How do I delete several rows that don't have the word total. I want to keep
the rows with word total in column A.
Thanks

 

[Barb Reinhardt]

Do an autofilter and look for CONTAINS Total. Delete the rows you want.

 

[Don Guillett]

Easiest would be to sort and delete or data>filter>autofilter>delete or a
looping macro

 

[David Biddulph]

Try autofilter? Custom/ does not equal/ Total, then Delete row, should
leave the ones with Total.
Save the existing file first though, just to be on the safe side.