"Alt+Enter" as separator in TEXTJOIN()

[Goncalo_Ribeiro]

Hello everyone,

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:

string 1

string 2

etc.

Thanks in advance!

[#2]

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

[#3]

@PMF_EXCEL thank you for your quick response!

Maybe I did not explain myself correctly:

I have a list of text strings, one in each own cell:

A1: string 1

A1: string 2

A3: string 3 

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). 

However, I want to maintain the vertical layout in order to get the following result for cell B1:

string 1

* string 2

* string 3

Can I use Alt+Enter as the separator? If so, what should I write in the first argument of the TEXTJOIN() function?

Any thoughts? Thanks!

[#4]

A1&CAR(10)&A2&CAR(10)&A3

best

PMF_EXCEL

[#5]

@PMF_EXCEL
you mean CHAR(10)
so your solution would be:
=A1&CHAR(10)&A2&CHAR(10)&A3

[#6]

Thank you @Ramiz_Assaf and @PMF_EXCEL !

Worked like a charm! CHAR(10) also worked as the separator in TEXTJOIN() !

PS: in portuguese, TEXTJOIN is UNIRTEXTO and CHAR is CARÁT