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

  1. Double-click or drag the Replace action from the Excel advanced node in the Actions palette.
  2. Click the From drop-down menu and select one of the following options to specify the start of the cell range for search:
    • Beginning: Is the default option and 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.
  3. Click the Till drop-down menu to select one of the following options as the end point of the cell range for search.
    • Beginning: Is the default option.
    • End
    • Active cell
    • Specific cell
  4. In the Find field, enter the string that you are searching for in the Excel sheet.
  5. Use the Search options field to select one of the following options:
    • By rows: Is the default option and enables you to search the spreadsheet by rows.
    • By columns: Enables you to search by columns.
  6. Select Replace with and specify the replacement string, or leave the field blank to replace the matching cells with an empty character.
  7. Enter the name of the session used to open the workbook with the Open action.
  8. Click Save.
Consider a scenario where a financial analyst must update all occurrences of the value 1500 in a sales report spreadsheet to 2000for accurate reporting..
  1. Double-click or drag the Replace action from the Excel node in the Actions palette.
  2. Click the From drop-down menu and select Beginning.
  3. Click the Till drop-down menu and select End.
  4. In the Find field, enter 1500.
  5. In the Search options field, select By rows.
  6. In the Replace with field, enter 2000.
  7. In the Session name field, enter the name of the session used to open the workbook with the Open action.
  8. Click Save.

    All cells containing 1500 in the Excel spreadsheet are replaced with 2000, ensuring the updated sales report reflects the accurate values.