CONCATENATE function - Windows SharePoint Services

Home > Products > Windows SharePoint Services > Windows SharePoint Services 3.0 Help and How-to > Formulas and functions > Text and data

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

CONCATENATE function

Applies to: Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0

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)