|Subject:||Deleteing blank or "zero" cells|
|Posted by:||Alain Dekker (abdekk…@NOSPAM.fsmail.net)|
|Date:||Thu, 2 Oct 2003|
If I paste a long list of numbers that contains several blank cells, or
cells with a particular value in them (such as "0") that I want to delete,
how do I remove all these rows and create a new column with only the
unaffected values (.ie. non-blank, non-zero), without gaps?