Excel Find and Replace
Replace values across every sheet of a workbook at once - with match-case, whole-cell, and regex options.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb · up to 50MB · or paste a file from your clipboard
Which Cells Are Searched, and Which Are Not
Every cell in scope is examined, but only three kinds can be rewritten. Text cells match on their stored text. Number cells match on the digits actually stored, not on what the number format shows - so a cell displaying $1,200.00 is searched as 1200. Dates and TRUE/FALSE cells match on their displayed text but are replaced only when Whole cell only is on. Cells containing a formula are skipped outright, so your calculations and their cached results are never touched.
Count First, Then Apply
Nothing is modified while you type. As soon as the Find box has content the tool counts matches and shows them per sheet, split into cells affected and total occurrences - the two differ whenever a single cell contains the search text more than once. Only when you press Apply and Download is a modified copy built, and it is built from a fresh copy of the workbook, so you can adjust the options and preview again without the earlier run interfering.
The Three Options
| Option | Off | On |
|---|---|---|
| Match case | north finds North and NORTH | north finds only north |
| Whole cell only | North finds it inside North West | the cell must be exactly North |
| Regular expression | your text is matched literally, dots and brackets included | item-(\d+) matches, and $1 in the replacement returns the captured digits |
With regex off, every character you type is escaped, so searching for 1.5 will not accidentally match 135. With it on, the pattern is validated live and an error message replaces the match count until the pattern is valid. Whole cell only is what makes an exact-value replacement safe: it is the difference between changing the region code NW and mangling every cell containing the letters n and w.
Edge Cases Worth Knowing
Replacing inside a number cell keeps it numeric only when the result still parses as a number; 1200 to 1,200 silently becomes text and drops out of your SUMs. An empty replacement box is a valid deletion - useful for stripping a prefix from every code. Scope defaults to all sheets, which includes any sheet you were not thinking about, so switch to a single sheet when a term means different things in different tabs. The rebuilt file keeps values, formulas, sheet names, and number formats but not cell fonts, fills, or borders, and it is always written as .xlsx - an .xlsm workbook loses its macros in the round trip.
When a Different Tool Fits Better
If you are normalizing shape rather than replacing a known value - padded text, inconsistent capitalization, empty rows - Excel Data Cleaner does that in one pass with a report. If the change should stay live in the sheet rather than being baked into a downloaded copy, the SUBSTITUTE generator writes the formula. To collect matching values instead of rewriting them - every email in a notes column, say - use Excel Data Extractor, and to build a pattern before running it over a real workbook, test it in the Excel REGEX generator.
Frequently Asked Questions
A numeric cell is rewritten as a number only when the replaced text still reads as one. Turning 1200 into 1,200 or into 1200 USD produces something that is not a number, so the cell is stored as text - and any SUM over it then ignores it. Replace inside number cells only when the result is still numeric.
Neither. Any cell holding a formula is skipped entirely, so the formula text and its cached result are left alone. This is deliberate: rewriting a cached value would leave the sheet showing something its own formula does not produce.
Dates and booleans are matched on their displayed text but are only rewritten when Whole cell only is on. Replacing a fragment of a date would turn a real date into a string that looks similar but sorts and calculates differently, so the tool declines rather than doing that silently.
Standard JavaScript regex syntax. Find item-(\d+) and replace with #$1 rewrites item-42 as #42. The find field is validated as you type, and an invalid pattern shows the error instead of a match count.
Values, formulas, sheet names, and number formats survive. Cell fonts, fills, and borders are not carried through by the writer, and the download is always .xlsx - so an .xlsm workbook comes back without its macros. For a formatting-sensitive workbook, replace in a copy and compare before you rely on it.