The Replace action finds and replaces text in an Excel workbook.

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

1. Drag the Target Selector from the Build Pane Area to add new actions and edit existing actions. The Build Pane displays after you select a targeted element in a Windows application. The center of the Build Pane is referred to as the Task Editor Pane. and drop it onto an Excel worksheet column, table, row, cell range, or exact cell.

2. Select Replace.

3. Enter the text that you want to Find. Optionally, click the Magic Wand to use the Expression Builder.

4. Enter the text to be replaced in the Replace with text box. Optionally, click the Magic Wand to use the Expression Builder.

5. If you want to ignore the text case in your search, select Ignore case. This settings is off by default and therefore your searches are case sensitive.

6. Click Rules to modify how Nintex Bot finds the target.

7. If needed, adjust the Timing settings to fine tune how the action runs.

8. If needed, adjust the Run error task settings to fine tune how the action runs.

   • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
   • Stop on error: The botflow stops in the event of an error.
   • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action.

9. (Optional) Add a Note to document special instructions or functionality.

10. Toggle the run switch to Run and click OK to execute and save the action.

Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run. For more information, go to Action Builder.