Adding Carriage Return with MCONCAT

[Jim-in-I]

Is there a method to add a new line (carriage return) between the items resulting from MCONCAT?

=MCONCAT(range_1)

This works good with the cell Text Wrap feature, but my range items vary greatly in length and appear disjointed. I would like to have each item appear on a separate line.

Any ideas?

 

[Juan Pablo González]

How about

=MCONCAT(range_1,CHAR(10))

or

=MCONCAT(range_1,CHAR(13))

depending if you're on Win or Mac.

 

[Jim-in-I]

Thanks Juan,

I included the "CHAR(10)" option within my MCONCAT statement:
=MCONCAT(range_1,CHAR(10))
However, the range includes many blank cells, and this resulted in large spaces between each item.

Thanks again for the help, I will continue to explore methods to eliminate the blank lines.