Partial matches or whole cells
By default a rule replaces every occurrence inside a cell, so replacing “St.” with “Street” turns “Main St.” into “Main Street”. Tick Whole cell only when the entire value must match, for example to turn “N/A” and “n/a” into empty cells without touching “N/A” inside a sentence.
Filling blank cells
Leave Find empty, tick Whole cell only and type a replacement such as “Unknown” or “0”. Every empty cell in the chosen column is filled. This helps before importing into tools that reject empty required fields.
Regular expressions
With Regular expression on, Find is a JavaScript regular expression and the replacement can use groups such as $1. For example, find (\d{3})(\d{3})(\d{4}) and replace with ($1) $2-$3 to format 10-digit numbers, or find \s*\(.*?\) with an empty replacement to remove anything in brackets. Invalid patterns are flagged and skipped instead of breaking the file.