Function Index

Concat

Combine strings together.

Usage

Concat(<text 1>, <text 2>…)

text 1 (required) First part of the text to be combined.

text 2+ (optional) Additional text to add to <text 1>. No extra space is added between values.

NOTE: If you would like to add a number or date to a string, surround the number with quotes to have it be treated like a string or use the type indicator Text( ) to have a column of numbers be treated like a string.

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.