Concatenates the elements of the array passed to the function.
= CONCATENATE(args)
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). |
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.
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. |