The CONCATENATE function joins (concatenates) values or the contents of referenced cells.
CONCATENATE(string, string…)
string: Any value.
string…: Optionally include one or more additional values or cell references.
Notes
As an alternative to the CONCATENATE function, you can use the & concatenation operator.
Examples |
|---|
If cell A1 contains Lorem and cell B1 contains Ipsum, =CONCATENATE(B1, “, “, A1) returns “Ipsum, Lorem”. =CONCATENATE(60, 60) returns “6060”. =CONCATENATE(“a”, “b”, “c”) returns “abc”. =”a”&”b”&”c” also returns “abc”, because the ampersand is the concatenation operator. |