Replaces existing text with new text in a text string.
| Name | Type | Description |
| arg1 | string | The text or the reference to a cell containing text in which the characters will be substituted. |
| arg2 | string | The existing text to replace. If the case of the original text does not match the case of text, the function will not replace the text. |
| arg3 | string | The text to replace the original text with. |
| arg4 | string | Specifies which occurrence of the original text to replace. If omitted, every instance of the original text will be replaced. |
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.SUBSTITUTE("Online Office is a cloud business service portal", "Office", "portal"));
builder.SaveFile("xlsx", "SUBSTITUTE.xlsx");
builder.CloseFile();