Organize the returned value JOIN + COLLECT (?)

Victor.Silva

Hi guys, could you help me with a case? 

I don't know if it's possible, but is there any possibility of organizing the values returned to the cell in such a way that, starting with a symbol, the rest is organized right below, as in the next paragraph of the cell ? 

I'm saying this because with the combination of JOIN + COLLECT I managed to return all the values, but I wouldn't like them to be in an extensive way in the cell but in an organized way, one below the other. 

Thank you!

KPH

If you are trying to join the values from multiple cells into one cell and have each one start on a new line then you can use the line break character as the delimiter in your join function. CHAR(10) is a line break.

Your JOIN COLLECT might look like this:

=JOIN(COLLECT(.........), CHAR(10))