All articles with 'delete' Tag

How to remove all cells containing John (or anything else) [Quick tip]

Published on Mar 15, 2013 in Excel Howtos
How to remove all cells containing John (or anything else) [Quick tip]

Here is an interesting question someone asked me recently,

If I have to delete all rows with “John” in it. Do you know how to do it?

Well, it looks like they really hate John. But it is none of my business.

So lets go ahead and understand a dead-simple way to get rid of all cells with John or whoever else you fancy.

Continue »