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 column references.
Remark
The "&" operator can be used instead of CONCATENATE to join text items.
Example
Col1 |
Col2 |
Col3 |
Formula |
Description |
---|---|---|---|---|
brook trout |
species |
32 |
=CONCATENATE("Stream population for ",[Col1]," ",[Col2]," is ",[Col3],"/mile") |
Concatenates a sentence from the data (Stream population for brook trout species is 32/mile) |