thanks sean, worked ike a charm, one more question if you have the time. how
do I delete cells that are duplicates? is there a way to do this?

"Sean Timmons" wrote:

When you say delete them, are you attempting to delete the entire row? If so,
highlight your sheet, then Data - Filter - Autofilter. Pick (blanks) from
column A, highlight your resulting rows Edit - Delete.

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