Forum Discussion
Solved
How to force a line shift in the TEXTJOIN function in excel
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?
Terje Fachenberg Try something like this:
=TEXTJOIN(CHAR(10),TRUE,A4:C4)and set the cell with this formula to "wrap text".