Find and Replace with blank - How to, please?

[Silvabod]

One column of data 40000+ cells.

About 850 of these need to be blank.

Using Find 0 and replace with " " resulted in 850 cells containing " " Instead of being empty, as intended.

Using Find " " replace with (no entry) doesn't work either.

Can it be done, or is there an alternative command. Not a macro, this is a one-off and I'm useless at them.

[#2 · Accepted solution]

@Silvabod 

Leave the 'Replace with' box empty, and make sure that you tick the check box 'Match entire cell contents', then click 'Replace All'.

[#3]

SOLVED yes, this worked perfectly, thanks