Reference
No results for 'undefined'
    Powered by Algolia

    FIND_REPLACE

    Replaces part of a text string with a different text string using a replacing expression.

    Syntax

    =FIND_REPLACE(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

    Returns

    • Type: String
    • Description: Returns the resulting string

    Example

    =FIND_REPLACE(B7, ":([^\s]+)", "thing_" & @m1)

    See Also

    Contents