Newbie Help!

  • Thread starter Thread starter King_Mushroom
  • Start date Start date
K

King_Mushroom

Im am fairly new to MS excel. Ill try and describe my problem as best
can.

One of the lab technitions at work has an external 'grip tester' tha
sends road readings into an excel file on the fly.

My problem only relates to ONE column. Every now and then about four o
five readings are put in, followed by around 10 blank spaces. and so o
and so on all the way DOWN the page.

What this guy has asked me is if there is a way to replace all th
'null values' (blank spaces) with a fixed one (i.e 3.5). Withou
replacing the scattered readings.

No good copy pasting as there are so many of these null value gaps.

So basicly is there a way to replace ALL certain values of a certai
column with certain value.

Thanks in Advance..
 
Select your range.
Edit|goto|special
Select Blanks
Click ok
(notice that your selection is now just those blank cells)
type your value -- 3.5
But hit ctrl-enter to fill those cells.

If you ever want to fill in those blank cells with the value above it, take a
look at Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html

(It's a nice way to copy|overlay)
 
Back
Top