I'm trying to delete a cell in excel if the content of the cell doesn't
have a specific word. For example if I only wanted cells if it
contained the word 'John' in it.
Then the cell: I love excel - would be deleted but the cell: I love
excel more than John - would not be deleted.

I'm sure it's probably a simple solution but I'm not really sure how to
do this.
Any help would be much appreciated.

Thanks