REPLACE Function (VisioShapeSheet)

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 )

Parameters

Name	Required/Optional	Data Type	Description
old_text	Required	String	The text in which you want to replace some characters.
start_num	Required	Number	The position of the character in old_text that you want to replace with new_text. The first character in the string is position 1.
num_chars	Required	Number	The number of characters in old_text that you want to replace
new_text	Required	String	The text that will replace characters in old_text.

Return value

String

Remarks

Use the REPLACE function when you want to replace text that occurs in a specific location in a text string. If you want to replace specific text in a text string, use the SUBSTITUTE function.

Example

REPLACE ("01/03/2002",9,2,"03")

Returns 01/03/2003.