REPLACE Operation

Definition

Example

Syntax Guide

Formula In Use

Definition

The REPLACE operation will replace part of a string with a different string.

Example

REPLACE("Pineapple",5,5,"nuts")

Result:
Pinenuts

Syntax Guide

REPLACE(text, position, length, new_text)

text - The text, a part of which will be replaced

position - The position where the replacement will begin (starting from 1)

length - The number of characters in the text to be replaced

new_text - The text which will be inserted into the original text

Formula In Use

What's Next? 

• Learn more about how to write formulas
• Check out the RSUBSTITUTE operation
• Check out the SEARCH operation