Forum Discussion
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 " " 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.
Leave the 'Replace with' box empty, and make sure that you tick the check box 'Match entire cell contents', then click 'Replace All'.
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
