CONCAT

Formula Explanation

Combines multiple strings together.

Formula Syntax

Enter in the result column: concat("string1", "delimiter (optional)", "string2", ...)

• All arguments can use column references, i.e., the codes at the top of each column in the table, e.g., AA1.

Usage Example

Concatenate values from columns BY2, BY3, BY4, and "today" with hyphens in between, and write the result into column BY5:

BY5 = concat(BY2, "-", BY3, "-", BY4, "-", "today")

✉️ Ask TableDI