Forum Discussion
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?
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)