REPLACE

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

Syntax

=REPLACE(OldText, StartAt, 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

The replaced Text.

Examples

Formula	Result	Comment
=REPLACE("Replace me now", 12, 3, "later")	"Replace me later"