Hi,

I have a list of data in a column that are lookup answers from across
several sheets in excel 2000. the data looks something like this:

black
0
blue
0
0
0
green
0
red

(the zeros are returned from blank cells)

I want to be able to concatenate all the words with a line break between
each on but suppress the lines with a zero so my end cell looks like this:

black
blue
red
green

i can manage =concatenate(a1,char(10),a2,char(10),etc....)
but i cant think how to suppress the zeros and still get a line break after
each word.
Any help would be great thanks.
Brett