LEFT 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

LEFT function

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

LEFT returns the first character or characters in a text string, based on the number of characters you specify.

Syntax

LEFT(text,num_chars)

Text is the text string that contains the characters you want to extract.

Num_chars specifies the number of characters you want LEFT to extract. Num_chars must be greater than or equal to zero. If num_chars is greater than the length of text, LEFT returns all of text. If num_chars is omitted, it is assumed to be 1.

Examples

Col1	Formula	Description (Result)
Sale Price	=LEFT([Col1],4)	First four characters in the string (Sale)
Sweden	=LEFT([Col1])	First character in the string (S)