Functions
REPLACE
Replace portion of text
Try it
When to use it
When should I use REPLACE instead of SUBSTITUTE?
Use REPLACE when you know the position and length of the text to swap out; use SUBSTITUTE when you want to replace text by matching its content.
What do the numbers in REPLACE mean?
The second argument is the starting position and the third is how many characters to remove; the fourth argument is the new text to insert there.
Use cases
Swap a slice of characters by position
Rename a fixed-length label
Used in
operations · sales · retail
Syntax
REPLACE(text, start, num_chars, new_text)