WorksheetFunction.Replace Method
Replaces part of a text string, based on the number of characters you specify, with a different text string.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Replace ( _
Arg1 As String, _
Arg2 As Double, _
Arg3 As Double, _
Arg4 As String _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As String
Dim Arg2 As Double
Dim Arg3 As Double
Dim Arg4 As String
Dim returnValue As String
returnValue = instance.Replace(Arg1, Arg2, _
Arg3, Arg4)
string Replace(
string Arg1,
double Arg2,
double Arg3,
string Arg4
)
Parameters
Arg1
Type: System.StringText in which you want to replace some characters.
Arg2
Type: System.DoubleThe position of the character in Arg1 that you want to replace with Arg4.
Arg3
Type: System.DoubleThe number of characters in Arg1 that you want the Replace(String, Double, Double, String) method to replace with Arg4.
Arg4
Type: System.StringText that will replace characters in Arg1.
Return Value
Type: System.String