Changes

=SUBSTITUTE(txt, otext, ntext, instnum)=

=SUBSTITUTE(txt, otext, ntext, instnum)=

where  

where  

*<math>txt</math> is the text or reference to cell containing text, from which certain string is to be substituted,

*<math>Text</math> is the text or reference to cell containing text, from which certain string is to be substituted,

*<math>otext</math> is the old text to be replaced,

*<math>OldText</math> is the old text to be replaced,

*<math>ntext</math> is the new text that replaces the characters in old text,

*<math>NewText</math> is the new text that replaces the characters in old text,

*<math>instnum</math> is the instance number that specifies which occurrence needs to be replaced.

*<math>InstanceNumber</math> is the instance number that specifies which occurrence needs to be replaced.

**SUBSTITUTE(), substitutes specific instances of old text with new text in a text string.

== Description ==

== Description ==

 

SUBSTITUTE (Text,OldText,NewText,InstanceNumber)

SUBSTITUTE(txt, otext, ntext, instnum)

 

For Example,

For Example,

SUBSTITUTE("WELCOME", "COME", "DONE", 1) returns ''WELDONE''

SUBSTITUTE("WELCOME", "COME", "DONE", 1) returns ''WELDONE''

In above example, first instance of old text is replaced with new text.

In above example, first instance of old text is replaced with new text.

*SUBSTITUTE function can be used to replace specific occurrences of the text.

*SUBSTITUTE function can be used to replace specific occurrences of the text.

*If <math>txt</math> is entered directly as a part of argument, it should be enclosed in quotation marks (e.g. "TEXT").

*If <math>Text</math> is entered directly as a part of argument, it should be enclosed in quotation marks (e.g. "TEXT").

*<math>otext</math> and <math>ntext</math> should be enclosed in quotation marks (e.g. "TEXT").

*<math>OldText</math> and <math>NewText</math> should be enclosed in quotation marks (e.g. "TEXT").

*If string specified in <math>otext</math> is not part of the reference string <math>txt</math>, Calci returns the original string <math>txt</math> as a result.

*If string specified in <math>OldText</math> is not part of the reference string <math>Text</math>, Calci returns the original string <math>Text</math> as a result.

*Argument <math>instnum</math> is optional. If omitted, all instances mentioned in old text are replaced by new text.

*Argument <math>InstanceNumber</math> is optional. If omitted, all instances mentioned in old text are replaced by new text.

*<math>instnum</math> should be an integer &gt; 0, else Calci displays #NULL error message.

*<math>InstanceNumber</math> should be an integer &gt; 0, else Calci displays #NULL error message.

== Examples ==

== Examples ==