WorksheetFunction.Substitute(String, String, String, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Substitutes new_text for old_text in a text string. 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.
public string Substitute (string Arg1, string Arg2, string Arg3, object Arg4);Public Function Substitute (Arg1 As String, Arg2 As String, Arg3 As String, Optional Arg4 As Object) As StringParameters
- Arg1
- String
Text - the text or the reference to a cell containing text for which you want to substitute characters.
- Arg2
- String
Old_text - the text you want to replace.
- Arg3
- String
New_text - the text you want to replace old_text with.
- Arg4
- Object
Instance_num - specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.