Forum Discussion

Richard Heinrichs's avatar
Richard Heinrichs
Copper Contributor
Jul 06, 2017

German function "VERKETTEN"

Hi,

 

i try to use the german function "VERKETTEN" the function works properly...

But i want to ad a linefeed in the function an i don find a possibility for this :-(

 

Anyone can help me?

Formulas & Functions
Need Help

2 Replies

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jul 07, 2017

    Hello,

     

    in Excel 2016 with Office 365 licensing you can use a new function called TextVerketten. 

    In English it is called TextJoin. As opposed to Concatenate (Verketten), it can take a range as an argument and you only need to specify the delimiter once. This is what the formula would be in English, with commas

     

    =TEXTJOIN(CHAR(10),TRUE,B1:B6)

     

    and in German with semicolon

    =TEXTVERKETTEN(ZEICHEN(10);TRUE;B1:B6)

     

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 06, 2017

    Hi Richard,

     

    I guess VERKETTEN is CONCATENATE for English version. For linefeed use CHAR(10), but your cell shall be formatted to wrap text:

     

Resources