"Alt+Enter" as separator in TEXTJOIN()

Question

Hello everyone,&nbsp;Is it possible to use Alt+Enter (ie. create a new text line inside the same cell) as a separator (first argument) for the text strings? I want my result to be:&nbsp;string 1string 2etc.&nbsp;Thanks in advance!

goncalo_ribeiro · Answer

Thank you&nbsp;Ramiz_Assaf&nbsp;and&nbsp;PMF_EXCEL&nbsp;!&nbsp;Worked like a charm! CHAR(10) also worked as the separator in TEXTJOIN() !PS: in portuguese, TEXTJOIN is UNIRTEXTO and CHAR is CARÁT&nbsp;&nbsp;&nbsp;&nbsp;

ramiz_assaf · Answer

PMF_EXCELyou mean CHAR(10)so your solution would be:=A1&amp;CHAR(10)&amp;A2&amp;CHAR(10)&amp;A3

pmf_excel · Answer

yes of course. You tape your text in the formula bar, and each time you do Alt+enter you create a new line Best PMF_Excel

goncalo_ribeiro · Answer

PMF_EXCEL&nbsp;thank you for your quick response!&nbsp;Maybe I did not explain myself correctly:&nbsp;I have a list of text strings, one in each own cell:&nbsp;A1: string 1A1: string 2A3: string 3&nbsp;&nbsp;I want to join them together in a single cell (e.g. B1) and I use the formula TEXTJOIN (" * ";1;A1;A2;A3). The result will appear in B1 as "string 1 * string 2 * string 3" [* is the separator between each string).&nbsp;&nbsp;However, I want to maintain the vertical layout in order to get the following result for cell B1:&nbsp;string 1* string 2* string 3&nbsp;Can I use Alt+Enter as the separator? If so, what should I write in the first argument of the TEXTJOIN() function?&nbsp;Any thoughts? Thanks!

pmf_excel · Answer

A1&amp;CAR(10)&amp;A2&amp;CAR(10)&amp;A3bestPMF_EXCEL

Forum Discussion

"Alt+Enter" as separator in TEXTJOIN()

6 Replies

Resources