Text functions

Concat

View as MarkdownOpen in Claude

The Concat function combines one or more text strings into a single string.

Syntax

Concat(string_1, string_2, ...)

Function arguments:

string_1(required) First string to combine in the sequence.
string_2+(optional) Additional strings to combine in the sequence.

Notes

  • Concat doesn’t automatically add spaces between strings. To add a space in the output, include " " as its own argument.
  • To concatenate a value of another data type with text data, convert the values to text using quotation marks or the Text function.
    • To concatenate a date value with a string, place quotation marks around the date value, such as "2024-01-01".
    • To convert values from a column of another data type to text, use the Text function, such as Text([ID Number]).
  • Optionally, use the & operator to concatenate multiple text values for concision. For example, Concat([First Name], " ", [Last Name]) is equivalent to [First Name] & " " & [Last Name].

Examples

Concat("queen", "bee")

Returns queenbee.

Concat("queen", " ", "bee")

Returns queen bee.

Concat([Name], Text([ID No]))

Combines a column of names with their corresponding ID numbers. For example, if the Name column contains John and the ID No column contains 123, the output is John123.

Concat([Store Region], "\n", [Store State])

When the newline character (\n) is added as an argument, the subsequent argument is displayed on a new line. To view the output on separate lines in Sigma, select More options > Wrap text .

A table shows the output of the formula Concat([Store Region], "\n", [Store State]). A user hovers over wrap text to demonstrate that the output is on separate lines