Newbie Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

King_Mushroom - 14 Apr 2004 02:19 GMT

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..

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Dave Peterson - 14 Apr 2004 02:33 GMT

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)

> Im am fairly new to MS excel. Ill try and describe my problem as best i
> can.
[quoted text clipped - 19 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message