CONCATENATE function

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)
 
 
Applies to:
SharePoint Foundation 2010 , SharePoint Server 2010