How to populate null cells with a zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I populate all null cells embedded in a data file with a zero without disturbing cells that are already populated
Thanks

Befor
25,398 (65,051) (99,112
85,899 (5,371) (124,199
(13,402
860 (1,571) (688

Afte
25,398 (65,051) (99,112
85,899 (5,371) (124,199
- - (13,402
860 (1,571) (688
 
Select your range. Choose Edit/Go To.../Special and select the Blanks
radio button.

Enter 0 using CTRL-ENTER
 
If you mean blank cells, select the range, press F5, click special,
select blanks, click OK type 0 and press ctrl + enter

I am not what you example describe though?

--

Regards,

Peo Sjoblom


JC said:
How can I populate all null cells embedded in a data file with a zero
Click to expand...
without disturbing cells that are already populated?
 
Hi JC
Type a zero in a cell you aren't using and then copy it. Select the range of cells where you want to paste the zero, including the cells which are already populated. On the pull down menu go to Edit>GoTo>Special>Blanks. Then Edit>Paste

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- JC wrote: ----

How can I populate all null cells embedded in a data file with a zero without disturbing cells that are already populated
Thanks

Befor
25,398 (65,051) (99,112
85,899 (5,371) (124,199
(13,402
860 (1,571) (688

Afte
25,398 (65,051) (99,112
85,899 (5,371) (124,199
- - (13,402
860 (1,571) (688
 
They are not blank, assuming that the other data are numbers try
constants and text and see if those cells get selected.
Do it on a backup copy...

--

Regards,

Peo Sjoblom


JC said:
As soon as I hit OK after choosing Blanks I got an error message showing
Click to expand...
"No cells were found". When I hit the OK button, everything went away. It
didn't give me a chance to input a zero. What did I miss?
 
Hi JE, you are right - they all contain spaces. What should I do? Trim the entire file
J

----- JE McGimpsey wrote: ----

You have no blank cells - is it possible that they have spaces in them
instead
 
Hi JC,
Say, as an example, that cell A1 is blank. In an unused cell enter =CODE(A1). If this returns a 32 then you do have spaces in the cells. You could the use Edit>Replace on the selection, as long as the populated cells don't have spaces in them.

Let us know what happened.

Good Luck,
Mark Graesser
(e-mail address removed)
Boston MA

----- JC wrote: -----

As soon as I hit OK after choosing Blanks I got an error message showing "No cells were found". When I hit the OK button, everything went away. It didn't give me a chance to input a zero. What did I miss?
Thanks.
JC

----- JE McGimpsey wrote: -----

Select your range. Choose Edit/Go To.../Special and select the Blanks
radio button.

Enter 0 using CTRL-ENTER
 
Hi Peo, those "blank" cells do contain spaces. Can you give me details as to how can I convert them into constant and text
Thanks for your help
J

----- Peo Sjoblom wrote: ----

They are not blank, assuming that the other data are numbers tr
constants and text and see if those cells get selected
Do it on a backup copy..

--

Regards

Peo Sjoblo


JC said:
As soon as I hit OK after choosing Blanks I got an error message showin
Click to expand...
"No cells were found". When I hit the OK button, everything went away. I
didn't give me a chance to input a zero. What did I miss
Thanks
J
Click to expand...
 
Mark, the =Code(cell address) test did return 32. The problem is then fixed by using Edit>Replace as you suggested. Thank you all for helping me out on this small but annoying problem
J

----- Mark Graesser wrote: ----

Hi JC
Say, as an example, that cell A1 is blank. In an unused cell enter =CODE(A1). If this returns a 32 then you do have spaces in the cells. You could the use Edit>Replace on the selection, as long as the populated cells don't have spaces in them

Let us know what happened

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- JC wrote: ----

As soon as I hit OK after choosing Blanks I got an error message showing "No cells were found". When I hit the OK button, everything went away. It didn't give me a chance to input a zero. What did I miss
Thanks
J

----- JE McGimpsey wrote: ----

Select your range. Choose Edit/Go To.../Special and select the Blanks
radio button

Enter 0 using CTRL-ENTE
 
Back
Top