Download and install the free add-in Morefunc.xll from:

http://xcell05.free.fr/morefunc/english/index.htm
then use this formula

=SUBSTITUTE(MCONCAT(IF(A1:A15<"",A1:A15&CHAR(10), "")),CHAR(10),"",COUNTA(A1:A15))

ctrl+shift+enter, not just enter


"cindyc" wrote:

I'm trying to concatenate 15+ columns into one and have the results appear in
list format- so I've used =concatenate(a1,char(10),a2,char(10),a3.....
function. Wrap text is enabled. However, some source columns contain blanks
and I don't want a blank row showing (it will make my row height huge!) and
make the list look odd with big blank spaces. Any ideas?