REPLACE

Replaces part of a string value, based on the number of specified characters, with a different text.

Syntax

=REPLACE(OldText, StartPos, NumChars, NewText)

Arguments

Name

Description

OldText

String in which to replace characters.

StartAt

Character position in OldText at which replace starts.

NumChars

Number of characters from StartAt to be replaced by NewText.

NewText

The text which will replace specified characters in OldText.

Return Value

The replaced Text.

Example

Function

Result

=REPLACE(“Replace me now”, 12, 3, “later”)

“Replace me later”