Replace in cells
replace_cellsReplace literal text in Excel cells or sheets, including formula text, then retype entries like Excel. Returns the cells changed.
Instructions
Replace text in cells, like Excel's Replace All (literal, no wildcards). The result is retyped as in Excel: '1' becomes a number, '=...' a formula. Returns cells changed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| exact | No | Match whole cells. | |
| query | Yes | ||
| sheet | No | Default: all sheets. | |
| in_formulas | No | Also replace inside formula text. | |
| replacement | Yes | Text to put in its place; '' deletes. | |
| case_sensitive | No |