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
See Also