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")