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
string 2
etc.
Thanks in advance!
6 Replies
- PMF_EXCELCopper Contributoryes 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_RibeiroCopper Contributor
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!
- PMF_EXCELCopper Contributor
A1&CAR(10)&A2&CAR(10)&A3
best
PMF_EXCEL