REPLACE Function

Replaces a string of characters, starting at a given position and ending a given number of characters beyond.
Sample Usage
REPLACE("Hello Dorld!", 7, 1, "W")
Syntax
REPLACE(
  • text
  • start_position
  • num_chars
  • new_text
)
  • text
    —
    The text to replace.
  • start_position
    —
    From the left, the character starting position (including spaces) that you want to replace.
  • num_chars
    —
    The number of characters to replace.
  • new_text
    —
    The replacement text.
Related Functions
LEFT
RIGHT
MID
SUBSTITUTE
FIND
Was this article helpful?
YesNo