Combine strings together.
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.
- Returns “queenbee”
Concat(“queen”, ” “, “bee”)
- Returns “queen bee”
Concat ([Name], Text([ID No]))
- Combines a column of names with their corresponding ID numbers.
More About Text Functions
Text functions analyze or manipulate string data and are useful sanitizing string input.
When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”
If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”