WorksheetFunction.Substitute(String, String, String, Object) Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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 String

Parameters

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.

Returns

String