Use a copy of your data first to experiment........
Highlight the dataset and SORT ascending on the column with the
blanks.........the blank rows will all go to the bottom of the list........

Vaya con Dios,
Chuck, CABGx3



"carl" wrote:

I have a set of data that has a blank in every other row. Is there a way to
remove these blanks ? I tried the paste special but to no avail.

Thank you in advance.

Carl