Arne

By "remove" I assume you want those cells deleted, not just turned blank.

Which way would you want them shifted.....up or left?

Then in which orientation would you want the remaining data placed into the one
column?


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 07:21:40 -0800, Arne Hegefors
wrote:

Hi! I have a large matrix. Some of the cells contain the value 0. I want to
get a new clean matrix where all 0 cells are removed. I then want to change
the matrix into a long column. The cells that contain 0 shall be removed and
not just replaced with another value. Is that possible? if so how? any help
appreciated!