Searches in a specified range for a certain value and either returns the address of the cell where it is found or replaces the value with another given value. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.
- Operation - Select an operation between Find, Replace, and Replace all. Depending on the chosen operation, different fields are displayed in the activity.
- Where to search - Click Plus