Substitute()

Substitute()

Category: Text

Syntax: Substitute ( text ; searchString ; replaceString )

Parameters: text ”any text string or expression that returns a text string; searchString ”any text string or expression that returns a text string; replaceString ”any text string or expression that returns a text string.

Description: Returns a text string in which all instances of searchString in the text parameter are replaced with the replaceString .

Examples:

 Substitute ("Happy Anniversary!" ; "Anniversary" ; "Birthday") 

Returns Happy Birthday! .

 Substitute ("This is a test"; "i" ; "q") 

Returns Thqs qs a test .

Comments:

Multiple substitutions may occur in the same Substitute() function:

 Substitute ("This is a test"; ["i"; "q"]; ["s"; "$"]) 

Returns Thq$ q$ a te$t .

The Substitute() function is case sensitive.