How can I remove cells containing specific values in Microsoft Excel

Question

How can I remove cells containing specific values in Microsoft Excel. What I have is different columns and I just want to remove the cells containing 0 from that particular column. I found this link http://superuser.com/questions/324377/answer/submit but it searches for the whole sheet, i just need specific column

Cheers,

Answer 1

If you highlight just the column in question, then you should be able to use replace and it will replace values in only that column. Alternatively, you could do the replacement in Google Refine, which has powerful clean-up features.