Removing Blanks

C

carl

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
 
R

Ron Coderre

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
 
C

CLR

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
 
Top