show / hide menu


This function returns a new string in which all occurrences of a specified Unicode character or String in the current string are replaced with another specified Unicode character or String.


StringReplace(ActualValue,Old Value,New Value).


Actual value is the given input string.

Old value is the value that has to be replaced.

New Value is the value with which the old value has to be replaced.


Textbox1.Value= StringReplace(Textbox1.Value, Good, Nice)
Textbox1.Value=”Very Good”

The function will replace “Good” with “Nice” and will return “Very Nice”.