Using the Replace action

Use the Replace action to find cells that contain a specific string and replace it with another string. This action supports .xlsx, .xlsm, and .csv files.

Procedure

Double-click or drag the Replace action from the Excel advanced node in the Actions palette.
Click the From drop-down menu and select Beginning.
- Beginning: Starts the search from the beginning of the spreadsheet.
- End: Starts the search from the end of the spreadsheet.
- Active cell: Starts the search from the active cell in the spreadsheet.
- Specific cell: Enables you to specify the address of the cell from where you want to start the search.
Click the Till drop-down menu and select End.
Use the Find and Till menu to specify the start and end point of the cell range for search.
In the Find field, enter 1500.
From the Search options, select By rows.
The By rows option enables you to search the spreadsheet by rows, while the By columns enables you to search by columns.
Select Replace with and specify the replacement string, or leave the field blank to replace the matching cells with an empty character.
Enter the name of the session used to open the workbook with the Open action.
Click Save.

Automation 360

Using the Replace action