Delete special rows in Excel?

I want to delete the rows which have special words. for example the three colum开发者_如何学Pythonns data:

10 s 123

24 c 235

33 s 345

46 s 346

59 s 546

62 c 277

Now I want to delete the rows that have the word "s" and I want just the remaining rows:

24 c 235

62 c 277

thanks

---

Turn on autofilter, and filter for rows that contain "s". Then delete the rows that are showing. Alternately, you can filter for rows that do not contain "s" and copy/paste them into another spreadsheet, depending on what your actual criteria is.