Forum Discussion
Solved
Find and Replace with blank - How to, please?
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 " " rep...
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
