Could you use the DataFilterAutofilter to find those rows with the specific
word then delete those visible rows.
Select the filtered rows and F5SpecialVisible cells onlyOK
Then EditDeleteEntire Row.
Gord Dibben Excel MVP
On Fri, 30 Sep 2005 16:19:02 -0700, "SafariQn"
wrote:
Is there a way to do a search in an excel spreadsheet for a specific 'word'
and have all pertinent lines deleted? I have a spreadsheet of over 11,000
lines and need to delete all lines that contain a specific word - doing this
manually is outrageous. I tried conditional formatting, but this does not
work. Help would be appreciated!
|