Search & Replace

Key Features

• Find & Replace – Replace all occurrences of a value across your dataset.
• Column restriction – Optionally limit replacements to a specific column by entering its index.
• Case sensitivity – Toggle Match case to distinguish between uppercase and lowercase.
• Regex support – Use regular expressions for advanced search patterns (e.g., ^\d+$ to match numbers).
• Whole cell matching – Restrict replacements to exact cell matches instead of partial matches.
• Feedback – Shows the number of replacements made, or errors if an invalid regex is used.

How to Use

1. Open the Find and Replace dialog.
2. Enter the text you want to find.
3. Enter the text you want to replace with.
4. (Optional) Enter a column index to only target that column. Leave blank to search all columns.
5. Enable or disable the checkboxes:
   • Match case – Only match exact uppercase/lowercase.
   • Use regex – Interpret your find text as a regular expression.
   • Whole cell – Only replace if the entire cell matches.
6. Click Replace All to apply changes across the dataset.
7. Click Close to exit without changes.

Examples

Basic replace: Find NY, replace with New York → All “NY” cells are updated.

Case-sensitive: Find apple, Match case ON → replaces “apple” but not “Apple”.

Regex: Find ^\d3$, Replace with ### → Any 3-digit cell is replaced with ###.

Whole cell: Find CA, Whole cell ON → replaces cells that are exactly “CA”, not “Canada”.