Replace all instances of the specified text with the new value.
Type: Import/Export Rule
Example: Replace all delimiters
Cell value: 1, 234, 567.89
Rule values:
Replace text: , (a single comma)
With text: (an empty space)
Result: 1 234 567.00
Example: Replace all <p> and </p> tags
Note: This case cannot be achieved with only one iteration. If the specified text cannot be modified with a single iteration of a rule, additional rules should be created to modify the text.
Cell value: <p>value</p>
Rule values:
Replace text: <p>
With text: (an empty space)
Result: value</p>
After adding this rule, add a second rule to replace all </p> tags