How to force a line shift in the TEXTJOIN function in excel

[Terje Fachenberg]

I am trying to input a line shift in a TEXTJOIN function so that the text that is joined will appear under each other rather than in a string. Is this possible?

[#2]

@Terje Fachenberg Try something like this:

=TEXTJOIN(CHAR(10),TRUE,A4:C4)

and set the cell with this formula to "wrap text".

[#3 · Accepted solution]

@Riny_van_Eekelen 

This worked fine. Thank you!