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: