Select the column then F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 14:01:01 -0700, gleakos
wrote:

I need to fill in the blank cells with the information from the cell above
until the next cell is not null. For example:
Column A
Bill
blank
blank
Bob
I need the blanks to read as Bill. Is there a function or something I can
use.