Substitutes new_text for old_text in a text string.
Object Model
Syntax
'Declaration Public Class CalcSubstituteFunction Inherits CalcBuiltinFunction
'Usage Dim instance As CalcSubstituteFunction
public class CalcSubstituteFunction : CalcBuiltinFunction
Remarks
Use SUBSTITUTE when you want to replace specific text in a text string. use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Inheritance Hierarchy
System.Object
GrapeCity.CalcEngine.Functions.CalcFunction
GrapeCity.CalcEngine.Functions.CalcBuiltinFunction
GrapeCity.CalcEngine.Functions.CalcSubstituteFunction
Requirements
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)
See Also