Replace first instance

Replace the first instance of the specified text with the new value

Type: Import/Export

Description: Searches the cell value and replaces the first instance of the found string with a new value.

Scope: The rule only applies to the first instance. All following instances will be ignored.

Also see Replace All Instances

Example

• Cell value: 1, 234, 567.89

• Rule values:

  • Replace text: , (a single comma)

  • With text: (an empty space)

• Result: 1 234, 567.00