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.