select the column A | press F5 | click special | choose blanks | ok |
right click on the col A | delete | choose shift cells up | ok


On Sep 26, 1:56*pm, red14red
wrote:
Basic question. I have a huge database in Excel with 8000 names in column A.
Some of these columns are blank. I need to line up all the blank cells and
delte them thus leaving all of the cells with values. Is there a way to do
this other than manually deleting the blank cells. Thanks in advance.