I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions.
In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which contains the word "Impact" without deleting the cell itself.

Well just highlight all the cell you want to clear by pressing ctrl and clicking them, then right click on one of the highlighted cells and select 'clear contents' from the popup. I use Office 2010, i don't know if other versions work the same but I believe they do.