Forum Discussion
"Alt+Enter" as separator in TEXTJOIN()
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 strin...
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
Quick note on this: for me it only worked if I have the "Wrap Text" option open.
Don't know if it's an error on my end, but good to keep in mind.
