I know this is so easy, but it seems most people asking for this are asking for more complicated things.
What's the easiest way to look at column H, if any cell contains a certain word, then clear the whole cell?
Also, if any cell in column H contains a certain word, delete only that word.