CONCAT

Returns the concatenation of two values. Equivalent to the `&` operator.

Sample Usage

CONCAT("de","mystify")

CONCAT(17,76)

Syntax

CONCAT(value1, value2)

  • value1 - The value to which value2 will be appended.

  • value2 - The value to append to value1.

Notes

  • value1 and value2 can be any scalar value or reference to a scalar value, including numeric and text types.

Examples

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false