Replace Null Values in a Column

[Steve C]

I need to replace null values in all the cells of a column with the value in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7

 

[Ragdyer]

You can do it right in the same column.

Select your range
Hit F5
Click "Special"
Click "Blanks"
Then <OK>
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl> <Enter>

 

[FSt1]

hi
you could use a helper column next to the column with the null values.
assuming the values are in column A, in the helper column put this...
=if(A2="",A1,A2)

Regards
FSt1

 

[Debra Dalgleish]

There are instructions here for filling the blank cells in a column:

http://www.contextures.com/xlDataEntry02.html

Or, if you need to do it in the adjacent column, you can use a formula.
For example, in cell B2: =IF(A2="",B1,A2)

 

[David Biddulph]

For A1, read B1?
--
David Biddulph

hi
you could use a helper column next to the column with the null values.
assuming the values are in column A, in the helper column put this...
=if(A2="",A1,A2)

Regards
FSt1