CONCATENATE

Concatenates the elements of the array passed to the function.

Syntax

= CONCATENATE(args)

Parameters

Args

An array whose elements have to be concatenated.  The array can contain integers (e.g., 37), decimal values (e.g., 37.48), strings, or values of a variable (e.g, UnitPrice).

Return Type

String

In the case of an error, the function displays an error message: “CONCATENATE(args): Error message”

The function can be used in combination with other functions.

Examples

Example

Returns

= CONCATENATE(“This”, “is”, “good”)

This is good

= CONCATENATE(“$”,1234)

$1234

= CONCATENATE(FirstName, “.”,  LastName)

The value of FirstName and LastName concatenated with a “.” as separator.

= CONCATENATE(UPPER( “Iron Speed”), “DESIGNER”)

The concatenated version of the string passed and the upper case converted string.

= CONCATENATE(“Iron”, SUBSTRING(“Iron Speed Designer”, 5, 5))

A concatenated version of the extracted string with the passed string.