Deleting rows conditionally

I am trying to automate a particular function in Ms Excel 2013 (and later). The details are as follows:   If a particular field has a particular string, I would like the entire row to be deleted. ...