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.
-
Select an option from the From list to specify a starting point of the cell range for search:
- 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.
-
Select an option from the Till list to specify an end
point of the cell range for search:
- Beginning: Ends the search at the beginning of the spreadsheet.
- End: Ends the search at the end of the spreadsheet.
- Active cell: Ends the search at the active cell in the spreadsheet.
- Specific cell: Enables you to specify the address of the cell where you want to end the search.
- Specify the string you want to search for in the Find field.
-
Select from the following search options:
- By rows: Enables you to search by rows.
- By columns: Enables you to search by columns.
- Match by case: Only performs this action on cells that contain a string that matches the uppercase and lowercase characters of the string you specified in the Find field.
- Match entire cell contents: Enables you to find only those cells that contain the entire string you have specified in the Find field.
- Select Replace with and specify the replacement string.
- 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.