Find and Replace with blank - How to, please?

Copper Contributor

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 Replies
best response confirmed by Silvabod (Copper Contributor)


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



SOLVED yes, this worked perfectly, thanks