Replace

Description of formula:
REPLACE function, replaces all instances of the specified fragment of the text with a new value.
Syntax:
REPLACE(text, oldValue, newValue)
or
REPLACE(text, oldValues, newValues)
Parameters:
text (type:Text)
Text in which you want to replace the value
oldValue/oldValues(type:Text or Text array)
Fragment or fragments that will be replaced.
newValue/newValues (type:Text or Text array)
Fragment or fragments that will be inserted into the old value or values place.
Returned type:
Text
Examples:
=replace('text to replace', 'text', 'fragment')
=replace('text to replace', 'text', 'section1.A2')
=replace(section1.A1, section1.A2, section1.A3)
=replace(section1.A1, section2.A2:A4, section3.A2:A4)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk