Replace blank cells with ZERO using Find Replace

What is the code blank cells

Would CTRL H work on this , find and replace with ?

Originally Posted by RudiS

Select the range containing the blank cells
Open Find/Replace (CTRL+H)
Leave the Find box blank (empty)
Type a zero into the Replace box
Click Replace All

It depends on what the OP means by "blank cells." This procedure will work if a cell contains text and that text is the null string. An example would be typing a single quote ' into a cell.

However, if what is meant is "an empty cell" or "cell with no data and no formula" this will not work.

Yeah RUDIS it works , I though it would
not work , ouch I should have tried before
asking