Find Blank Cells

  • Thread starter Thread starter Peter Thomas
  • Start date Start date
P

Peter Thomas

I wish to replace the blank cells in a large database with
a zero (0). I cannot figure out how to find a blank cell
using the Find and Replace option under the Edit menu.
Can anyone show me the way?
 
Hi Peter,

I always use CTRL+H to bring up the find and replace menu, leave the
fine part empty, and put in what you want to replace it
with....however, I do notice you say in a "database"? Do you mean in
Access??

Dave M.
 
What I like to do is select the area I want, then
select 'Edit' 'Goto' 'Special' and select 'blank cells'.
That should have highlighted all blank cells, then type 0
and then hit 'Ctrl' and 'Enter' keys at the same time.
The 'Ctrl' key, while selected with the 'Enter' key, acts
as a 'apply to all' or 'fill' type function.
 
Back
Top