Replace cell values in an action

You can use the action to replace values in specified cell or range.

You can select either replace with the value after formula evaluation, or replace with a string with the specified condition.

Tip

If a cell is designated as input prohibited, it will also be replaced.

Replace with the value after formula evaluation

  1. Drag ‘Replace cell(s)’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Specify the cell that contains the formula to be replaced by the value after evaluation.
../../../../_images/img_01.en16.png
  1. Select ‘Value after formula evaluation’ from the drop-down list.
../../../../_images/img_02.en15.png

Replace with a string with the specified condition

  1. Drag ‘Replace cell(s)’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Specify the cell containing the string to be replaced.
../../../../_images/img_03.en10.png
  1. Select ‘Specified string’ from the drop-down list.
../../../../_images/img_04.en9.png
  1. Specify the string to find and the string after replacement.
../../../../_images/img_05.en8.png

Tip

The behavior of string replacement is the same as when you perform replacement without specifying all options in the Find and Replace dialog.