CONCATENATE(text_list)

The CONCATENATE function joins several text items into one text item. text_list can be composed of text, numbers or single-cell references.

For example, if the cell A1 contains the number 5, the formula:

CONCATENATE("Petrol is $", A1, " today")

returns "Petrol is $5 today".

An abbreviated version of this function is CONCAT.

See:

CONCAT

Other text functions