The CONCATENATE function returns a string assembled from multiple strings.
This function can be useful when you need to create a complete text from separate parts, for example, to combine a first and last name or to merge an address.
Syntax
CONCATENATE(string1, [string2, ...])
Argument |
Description |
Permitted values |
|---|---|---|
string1 |
Original text |
Text string or reference to a cell containing text |
[string2, ...] |
(optional) Additional strings that need to be combined |
Text string or reference to a cell containing text |
Examples of use
Combining two strings
If you have “Joe” in cell A1 and “Black” in cell B1, you can combine them as follows:
=CONCATENATE(A1, " ", B1)
Result: “Joe Black”.
Combining data from multiple cells
If you want to combine the first name, last name, and age, for example, in cells A1, B1, and C1:
=CONCATENATE(A1, " ", B1, ", ", C1, " years old")
The result: "Joe Black, 30 years old".
Creating a string with the result of a formula calculation
=CONCATENATE("Total amount: ", SUM(A1:A10))
Result: “Total amount: 1000” (if the sum of the values in cells A1:A10 is 1000).
Notes
The CONCATENATE function does not automatically add spaces between texts, so you need to add them manually if necessary.