WorksheetFunction.Substitute method

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

string Substitute(
	string Arg1,
	string Arg2,
	string Arg3,
	Object Arg4
)

Parameters

Arg1
Type: System.String

Text - the text or the reference to a cell containing text for which you want to substitute characters.

Arg2
Type: System.String

Old_text - the text you want to replace.

Arg3
Type: System.String

New_text - the text you want to replace old_text with.

Arg4
Type: System.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.

Return value

Type: System.String
Show: