Chain function in Excel - so it'll work

The chaining function enables you to link several cells in Excel in another cell. We show you how to use the function.

Excel: Use the chaining function

The specified functions are shown in square brackets, they do not belong to the actual syntax.

• The basic syntax of the function is [= CHAINED (cell1; "text"; cell2)].
• The function can be expanded up to 255 characters and connects the values ​​of the cells.
• If you want to connect cell A1 (with the content "CHIP") to cell B1 (with the content "Online"), type in the entry line [= LINKING (A1; ""; B1)]. You get the value "CHIP Online".
• A1 and B1 refer to the values ​​of the cells. The content between the quotation marks ("") refers to the text to be added. A space is thus inserted between A1 and B1.
• You can form sentences by adding words between the quotation marks.
• Another example with the table values: A1 (content: CHIP), B1 (content: online) and C1 (content: practical tips). Enter the formula [= CHAINING ("Helpful"; C1; "from"; A1; ""; B1; ".")] And you will receive the sentence "Helpful practical tips from CHIP Online.".
• Tip: Instead of using the "CHAIN" command, you can use the "&" character to connect cells. So the formula [= "Helpful" & C1 & "from" & A1 & "" & B1 & "."] Produces the same result as in the example above.

We will show you how to add an if-then function in Excel in the next practical tip.