# Find Replace

Find/Replace searches a table for provided string and replaces it with another string. Multiple find/replace rules may be applied in a single tool, and they may be applied to an entire table or specified columns.

<figure><img src="https://1817223046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5mI0ilekQtcGTXKGQ2EF%2Fuploads%2FPq6VrbGs41nn28Fjr3it%2FProperty%201%3DFind%20Replace.jpg?alt=media&#x26;token=d309a14e-db83-4ecb-a080-426e0df731a3" alt=""><figcaption></figcaption></figure>

Three options exist for how to identify strings within the given table:

* **Find by string**: enter strings to find/replace. Option to allow matches with entire cells or partial matches within cells.
* **Find by regex**: use regular expressions to match cell segements. Replace with the provided string.
* **Find by delimiter**: Enter starting and ending delimiters, any strings between the provided delimiters will be replaced.

To find/replace null values, select "Find by String" and simply type "null" into the find box.