CONCATENATE

Joins multiple text strings into one single combined text value.

The CONCATENATE function joins two or more text strings into a single text string. This function is commonly used to combine text values, labels, and formatted outputs.

Syntax

CONCATENATE(string1, string2, ...)

Arguments

• string1: The first text string to join.
• string2, ...: Additional text strings to join.

Return value

Returns a single text string that combines all specified text values.

Example

CONCATENATE("Total Sales: ", "5000")

Returns Total Sales: 5000.

Excel equivalent

CONCATENATE