Setting Replacement to the empty string can be used as a mechanism to delete matched characters.įlags or Occurrence is one of the following options: Replacement is a text string (in quotation marks), or a reference to a cell containing a text string, that is the replacement text to be used. Text is a text string (in quotation marks), or a reference to a cell containing a text string, that is the original text to which Expression is to be applied.Įxpression is a text string (in quotation marks), or a reference to a cell containing a text string, that is the regular expression to be applied to Text. A copy of the original text, unmodified.A copy of the original text, modified by replacing one or multiple matches. A copy of a substring extracted from the original text. For more information about the occurrence of each return type (with examples), see the #Additional details: section below. Returns one of the following depending on argument values. Matches a text string against a regular expression and either extracts or replaces the matched text, depending on argument settings.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |