Reference
No results for 'undefined'
    Powered by Algolia

    REPLACE

    Replaces part of a text string with a different text string.

    Syntax

    =REPLACE(text, position, length, newText)

    Parameters

    1. text
      • Type: String
      • Description: The text, a part of which will be replaced.
    2. position
      • Type: Integer
      • Description: The position where the replacement will begin (starting from 1).
    3. length
      • Type: Integer
      • Description: The number of characters in the text to be replaced.
    4. newText
      • Type: String
      • Description: The text which will be inserted into the original text.

    Returns

    • Type: String
    • Description: Returns the resulting string

    Example

    =REPLACE(A2, "word", "Word", 2)

    Try It Now

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

    See Also

    Contents