Reference
No results for 'undefined'
    Powered by Algolia

    REGEXREPLACE

    Replaces part of a text string with a different text string using regular expressions.

    Syntax

    =REGEXREPLACE(text, [regexString], replacement)

    Parameters

    1. text
      • Type: String
      • Description: The text, a part of which will be replaced.
    2. regexString [optional]
      • Type: String
      • Description: The regular expression. All matching instances in text will be replaced.
    3. replacement
      • Type: String
      • Description: The text which will be inserted into the original text.

    Returns

    • Type: String
    • Description: Returns the resulting string

    Example

    =REGEXREPLACE("abfff", "ab(...)", "cde")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.

    See Also

    Contents