RIGHT 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

RIGHT function

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

RIGHT returns the last characters in a text string, based on the number of characters you specify.

Syntax

RIGHT(text,num_chars)

Text is the text string containing the characters you want to extract.

Num_chars specifies the number of characters you want RIGHT to extract.

Remarks

Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, RIGHT returns all of text.
If num_chars is omitted, it is assumed to be 1.

Examples

Formula	Description (Result)
=RIGHT("Sale Price",5)	Last 5 characters of the string (Price)
=RIGHT("Stock Number")	Last character of the string (r)