SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2078606%22%20slang%3D%22en-US%22%3EHow%20to%20force%20a%20line%20shift%20in%20the%20TEXTJOIN%20function%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078606%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20input%20a%20line%20shift%20in%20a%20TEXTJOIN%20function%20so%20that%20the%20text%20that%20is%20joined%20will%20appear%20under%20each%20other%20rather%20than%20in%20a%20string.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2078606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2078619%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20force%20a%20line%20shift%20in%20the%20TEXTJOIN%20function%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43452%22%20target%3D%22_blank%22%3E%40Terje%20Fachenberg%3C%2FA%3E%26nbsp%3BTry%20something%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTEXTJOIN(CHAR(10)%2CTRUE%2CA4%3AC4)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20set%20the%20cell%20with%20this%20formula%20to%20%22wrap%20text%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2079156%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20force%20a%20line%20shift%20in%20the%20TEXTJOIN%20function%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20worked%20fine.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

@Terje Fachenberg Try something like this:

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

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

Best Response confirmed by Terje Fachenberg (New Contributor)
Solution

@Riny_van_Eekelen 

 

This worked fine. Thank you!