"Alt+Enter" as separator in TEXTJOIN()

%3CLINGO-SUB%20id%3D%22lingo-sub-1603510%22%20slang%3D%22en-US%22%3E%22Alt%2BEnter%22%20as%20separator%20in%20TEXTJOIN()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603510%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20use%20Alt%2BEnter%20(ie.%20create%20a%20new%20text%20line%20inside%20the%20same%20cell)%20as%20a%20separator%20(first%20argument)%20for%20the%20text%20strings%3F%20I%20want%20my%20result%20to%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Estring%201%3C%2FP%3E%3CP%3Estring%202%3C%2FP%3E%3CP%3Eetc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603557%22%20slang%3D%22en-US%22%3ERE%3A%20%22Alt%2BEnter%22%20as%20separator%20in%20TEXTJOIN()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603557%22%20slang%3D%22en-US%22%3Eyes%20of%20course.%20You%20tape%20your%20text%20in%20the%20formula%20bar%2C%20and%20each%20time%20you%20do%20Alt%2Benter%20you%20create%20a%20new%20line%20Best%20PMF_Excel%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603593%22%20slang%3D%22en-US%22%3ERE%3A%20%22Alt%2BEnter%22%20as%20separator%20in%20TEXTJOIN()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765798%22%20target%3D%22_blank%22%3E%40PMF_EXCEL%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20your%20quick%20response!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20I%20did%20not%20explain%20myself%20correctly%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20text%20strings%2C%20one%20in%20each%20own%20cell%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA1%3A%20string%201%3C%2FP%3E%3CP%3EA1%3A%20string%202%3C%2FP%3E%3CP%3EA3%3A%20string%203%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20join%20them%20together%20in%20a%20single%20cell%20(e.g.%20B1)%20and%20I%20use%20the%20formula%20TEXTJOIN%20(%22%20*%20%22%3B1%3BA1%3BA2%3BA3).%20The%20result%20will%20appear%20in%20B1%20as%20%22string%201%20*%20string%202%20*%20string%203%22%20%5B*%20is%20the%20separator%20between%20each%20string).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20want%20to%20maintain%20the%20vertical%20layout%20in%20order%20to%20get%20the%20following%20result%20for%20cell%20B1%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Estring%201%3C%2FP%3E%3CP%3E*%20string%202%3C%2FP%3E%3CP%3E*%20string%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20use%20Alt%2BEnter%20as%20the%20separator%3F%20If%20so%2C%20what%20should%20I%20write%20in%20the%20first%20argument%20of%20the%20TEXTJOIN()%20function%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603621%22%20slang%3D%22en-US%22%3ERE%3A%20%22Alt%2BEnter%22%20as%20separator%20in%20TEXTJOIN()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603621%22%20slang%3D%22en-US%22%3E%3CP%3EA1%26amp%3BCAR(10)%26amp%3BA2%26amp%3BCAR(10)%26amp%3BA3%3C%2FP%3E%3CP%3Ebest%3C%2FP%3E%3CP%3EPMF_EXCEL%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603769%22%20slang%3D%22en-US%22%3ERE%3A%20%22Alt%2BEnter%22%20as%20separator%20in%20TEXTJOIN()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603769%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765798%22%20target%3D%22_blank%22%3E%40PMF_EXCEL%3C%2FA%3E%3CBR%20%2F%3Eyou%20mean%20CHAR(10)%3CBR%20%2F%3Eso%20your%20solution%20would%20be%3A%3CBR%20%2F%3E%3DA1%26amp%3BCHAR(10)%26amp%3BA2%26amp%3BCHAR(10)%26amp%3BA3%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603819%22%20slang%3D%22en-US%22%3ERE%3A%20%22Alt%2BEnter%22%20as%20separator%20in%20TEXTJOIN()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603819%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765798%22%20target%3D%22_blank%22%3E%40PMF_EXCEL%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorked%20like%20a%20charm!%20CHAR(10)%20also%20worked%20as%20the%20separator%20in%20TEXTJOIN()%20!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Goncalo_Ribeiro_0-1598016541076.png%22%20style%3D%22width%3A%20483px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213703i5E9A4D491A792250%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Goncalo_Ribeiro_0-1598016541076.png%22%20alt%3D%22Goncalo_Ribeiro_0-1598016541076.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPS%3A%20in%20portuguese%2C%20TEXTJOIN%20is%20UNIRTEXTO%20and%20CHAR%20is%20CAR%C3%81T%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

5 Replies
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

@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!

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

best

PMF_EXCEL

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

Thank you @Ramiz_Assaf and @PMF_EXCEL !

 

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

Goncalo_Ribeiro_0-1598016541076.png

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