Hi

I need some help creating a UDF that concatenates a RANGE of cells as
follows:-

1. If the cell is BLANK, do not concatenate it
2. If the cell is NOT blank, add a BULLET and SPACE to the start of
the text, concatenate it and add a <CR to the end.

This is to create a bulleted list of non-blank cells in a range, with
a <CR between each entry.

so if the range (a single column of data) looks like:

<blank
hello world
<blank
<blank
more data
<blank
end
<blank

I would end up with a text string as follows:

—� hello world
—� more data
—� end

Can anyone please help?

Many Thanks in advance...

NR