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'.
3 Replies
- SOLVED yes, this worked perfectly, thanks
Leave the 'Replace with' box empty, and make sure that you tick the check box 'Match entire cell contents', then click 'Replace All'.
I want to replace the word "Blank" with a completely empty cell. This puts a "'" at the beginning, which cannot be used in statistical calculations.
