Removing Blanks

[Guest]

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

 

[Guest]

If you want to delete the rows where the cells are blank, try this:

Select from the first item in the list down to the last item (or blank)
Press the [F5] key (that's the short cut for <edit><goto>)
Click the [special..] button
Check: Blanks
Click the [OK] button

WHILE the blanks are still selected
<edit><delete><entire row>

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

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