Find & Replace

  • Thread starter Thread starter Nolan
  • Start date Start date
N

Nolan

I need to find empty cells and replace with 0.
I thought I used to use "" to determine an empty cell or
maybe I've just gone brain dead.

Thanks
 
Hi Nolan!

Select the range
Edit > GoTo > Special
Check Blanks
OK
Type 0 then use Ctrl + Enter

But this will only cover cells that are blanks and will not affect
cells where formulas resolve to "".

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Did you really type in the double quotes?

I did an Edit|replace
I left "find what" empty
and put 0 in "replace with"

And it worked ok.

(you may want to select the range first to limit the scope.)
 
Back
Top