Concat
Combines strings together.
Usage
Concat(text 1, ...)
text 1 (required) First part of the text to be combined.
text 2+ (optional) Additional text to add. No extra space is added between values.
To add a number or date to a string, place quotes around the number. Use the type indicator Text(
)
to have a column of numbers treated like a string.
Example
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.