CONCATENATE

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2, ...)

Text1, text2, ...   are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

Remarks

The "&" operator can be used instead of CONCATENATE to join text items.

Examples

CONCATENATE("Total ", "Value") equals "Total Value". This is equivalent to typing
"Total"&" "&"Value"

Suppose in a stream survey worksheet, C2 contains "species", C5 contains "brook trout", and C8 contains the total 32.

CONCATENATE("Stream population for ",C5," ",C2," is ",C8,"/mile") equals "Stream population for brook trout species is 32/mile"