Thread: Delete rows with string

Hi, just wondering, I'm not new to excel or anything but never needed to do this before. I have a document with about twenty thousand rows in it and I need to delete every row that contains .mp3. Anybody, I've been looking and reading help files and asking and can't find this anywhere. Any help would be so appreciated. Thanks. If you know how to do this, just email me directly at <email address deleted> -- [teylyn]. I know I shouldn't put that out there but I am ready to throw **** at the wall right now. Thanks.

darkbreeze,

this is a public forum and all problems and solutions should be addressed publicly.

Please post a data sample of a few dozen rows and a solution can be provided to you in this forum by one of the members.

You could add an additional column with the formula

=COUNTIF(A1:Z1,"*.mp3*")

copy down to the last row. Then sort by that column in descending order and filter all rows that are not 0. Select and delete these rows.

cheers,