REPLACE function - Windows SharePoint Services

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

REPLACE function

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

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Syntax

REPLACE(old_text,start_num,num_chars,new_text)

Old_text is text in which you want to replace some characters.

Start_num is the position of the character in old_text that you want to replace with new_text.

Num_chars is the number of characters in old_text that you want REPLACE to replace with new_text.

New_text is the text that will replace characters in old_text.

Examples

Formula	Description (Result)
=REPLACE("abcdefghijk",6,5,"*")	Replaces five characters, starting with the sixth character (abcde*k)
=REPLACE("2009",3,2,"10")	Replaces the last two digits of 2009 with 10 (2010)
=REPLACE("123456",1,3,"@")	Replaces the first three characters with @ (@456)