Deleteing blank or "zero" cells

Giganews Newsgroups
Subject: Deleteing blank or "zero" cells
Posted by:  Alain Dekker (abdekk…@NOSPAM.fsmail.net)
Date: Thu, 2 Oct 2003

Hi,

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?

Thanks,
Alain

Replies