MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filling in the blanks

Posted by mitch on February 01, 2002 4:08 PM

working with a file that I need to go down a coloum and fill in the blank cells from the cell above it.

Posted by Barrie Davidson on February 01, 2002 6:40 PM

How about using a formula in an adjacent column and then copying the formula's result (values only) over the existing data. Assuming your data is in column A, put =A1 in cell B1 and this formula in B2:


Copy this formula down to the end. Then you can copy column B and paste values in column A.

BarrieBarrie Davidson