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.
boy.frenzy
0
Newbie Poster
Sterotech
0
Newbie Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.