Clearing cell based on criteria

Hi guys

I've got a pretty straightforward question. I should have been able to figure this out already but for some reason cannot...hopefully someone here can help out!

I have a column of data, lets say Column D.
Some values in Column D have the value ' #DIV/0! '
this is because the formula gave an error, so I want this changed to a blank cell.

Something like

For each cell in Column D
If cell.Value = "#DIV/0!" Then cell.Value = ""

Any thoughts?

thanks