# Find/Replace Value

> `UiPath.Excel.Activities.Business.FindReplaceValueX`

`UiPath.Excel.Activities.Business.FindReplaceValueX`

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](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) activity or with the Project Notebook.

## Configuring the activity

#### In the body of the activity

* **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** - Select **Plus** on the right side of the field and then, from the menu, select an Excel file, and then a sheet, table, or range where to search for the data, or select **Indicate in Excel** to indicate a range directly from the file. Alternatively, you can select **Custom Input** to enter a sheet name, table name, or range manually, or **Open in Advanced Editor** to enter a VB expression.
* **Value to find** - Select **Plus** on the right side of the field, and then, from the menu, select what to look for using one of the available options:

  + Data from the Project Notebook, a parent Excel file or email account. For example, select an Excel file, and then select **Indicate in Excel** to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value to search for.
  + **Use Saved Value** - Select a value that you previously saved for later use in the project.
  + **Text** - Enter the value using the Text Builder.
  + **Number** - Enter a numeric value.
  + **Paste from clipboard** - Paste a value that you previously copied to the clipboard in the project.
  + **Ask when run** - Prompt for a value when the project is executed.
  + **Open in Advanced Editor** - Enter a VB expression.
* **Replace with** - Value to replace with. Select **Plus** on the right side of the field, and then, from the menu, select the a value using one of the available options:

  + Data from the Project Notebook, a parent Excel file or email account. For example, select an Excel file, and then select **Indicate in Excel** to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value to replace with.
  + **Use Saved Value** - Select a value that you previously saved for later use in the project.
  + **Text** - Enter the value using the Text Builder.
  + **Number** - Enter a numeric value.
  + **Paste from clipboard** - Paste a value that you previously copied to the clipboard in the project.
  + **Ask when run** - Prompt for a value when the project is executed.
  + **Open in Advanced Editor** - Enter a VB expression.
* **Found at** - Location where the value was found when using the Find or Replace operations, no value is returned when using the **Replace all** operation. Select **Plus** on the right side of the field and then, from the menu, select where to save the result:

  + Select an Excel file and then a named cell, or select **Indicate in Excel** to indicate a cell from the file.
  + **Save for Later Use** - Save the result for later use in your project as input for another activity.
  + **Copy to clipboard** - Save the resulting value to clipboard.
  + **Open in Advanced Editor** - Enter a VB expression.

#### Properties panel

**Common**

* **DisplayName** - The name displayed for the activity in the Designer panel.

**Input**

* **Look in** - Specify whether to perform the search in **Values** or **Formulas**.
* **Match case** - If selected, searches for case-sensitive data.
* **Match entire cell contents** - If selected, searches for cells that contain just the characters that were entered into the **Value to find** field.
* **Operation** - See **Operation** in the body of the activity.
* **Replace with** - See **Replace with** in the body of the activity.
* **Value to find** - See **Value to find** in the body of the activity.
* **Where to search** - See **Where to search** in the body of the activity.

**Misc**

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.

**Output**

* **Fount at** - See **Found at** in the body of the activity.