CONCATENATE

Creates a new string by combining all specified strings into a single string

Syntax

=CONCATENATE(string1, string2, ..., stringN)

Arguments

Argument	Type	Description
string	String	The strings to combine

Examples

=CONCATENATE("ABC", "DEF", 'GHI")→"ABCDEFGHI"
Combines the strings "ABC", "DEF", and "GHI" into a single string

=CONCATENATE("Hello there, ", @Name, "!")→"Hello there, John!"
Combines the string "Hello there, ", the shape data property "Name", and the string "!"

=CONCATENATE("A", 1, true)→"A1true"
Combines the string "A", the number 1, and the boolean value true. Because the Lucid formula system automatically converts value to the correct type, it produces a string version of each value and then creates a string

=CONCATENATE("", "A", "")→"A"
Combines the strings "" (blank), "A", and "" (blank)