CONCATENATE

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.