Forum Discussion

Goncalo_Ribeiro's avatar
Goncalo_Ribeiro
Copper Contributor
Aug 21, 2020

"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_EXCEL's avatar
    PMF_EXCEL
    Copper Contributor
    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's avatar
      Goncalo_Ribeiro
      Copper 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_EXCEL's avatar
        PMF_EXCEL
        Copper Contributor

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

        best

        PMF_EXCEL

Resources