Excel Find & Replace
Find any text or number across your entire workbook and replace it in bulk. Preview every match before applying. Works across all sheets simultaneously. Your file never leaves your browser.
Drop your Excel file here
or click to browse — .xlsx, .xls, .xlsm, .xlsb
100% private — your file never leaves your browser
How to Find and Replace in Excel
Upload your file
Drag and drop your Excel file or click to browse. Multi-sheet workbooks are supported.
Enter find & replace text
Type the text to find and the replacement. Leave replacement blank to delete matches.
Find matches first
Click "Find Matches" to preview every match — sheet name, cell reference, and current value.
Replace & download
Click "Replace All & Download" to apply all replacements and save the updated file.
When Is Bulk Find & Replace Useful?
Excel's built-in Ctrl+H works well for interactive replacements, but this tool adds capabilities that matter for data cleaning:
- Rename a company or product across an entire reporting workbook in one pass
- Standardise inconsistent labels — replace “N/A”, “n/a”, “na”, “NA” with a consistent value
- Remove unwanted prefixes or suffixes — strip “USD ” from the start of currency cells
- Fix data imports — replace escaped characters (
&→&) that come through from web exports - Anonymise data — replace specific names or identifiers with anonymised placeholders before sharing
- Delete unwanted text — leave replacement blank to remove matched text from all cells
Frequently Asked Questions
Can I replace text across all sheets at once?
Yes. By default, the tool searches and replaces across all sheets in the workbook simultaneously. You can also restrict the operation to just the currently active sheet by selecting "Active sheet" in the options.
What is "match entire cell" and when should I use it?
"Match entire cell" means the cell's value must exactly equal the find text — partial matches are not replaced. For example, searching for "Inc" with whole-cell matching will not match a cell containing "Inc and Co." — only a cell containing exactly "Inc". Use this for precise replacements rather than substring replacement.
Can I delete text by leaving the Replace field blank?
Yes. Leave the "Replace with" field empty and click Find Matches, then Replace All. Any matching text will be removed (replaced with an empty string), or whole-cell matches will be cleared entirely.
Does this tool replace text inside formulas?
No. The tool operates on cell display values — the calculated result shown in the cell. Formula cells that match are converted to static values with the replacement text. Formula text itself (like =SUM(A1:A10)) is not modified.
Is there a limit to how many replacements can be made?
No hard limit — the tool will replace all matching cells across the entire workbook. For very large workbooks (millions of cells), replacement may take a few seconds.
Find & Replace Recipe Book
Common replacements teams run on real spreadsheets:
| Goal | Find | Replace with | Match entire cell? |
|---|---|---|---|
| Remove "USD " prefix | USD | (empty) | No |
| Standardise N/A variants | n/a | N/A | Yes (run for na, n/a, NA separately) |
| Rename a company | Acme Corp | Acme Corporation | No |
| Delete a word everywhere | Confidential | (empty) | No |
| Fix encoding artefact | & | & | No |
| Anonymise a name | John Smith | [Redacted] | Yes |
| Replace placeholder zeros | 0 | (empty) | Yes (whole-cell to avoid changing 100 → "") |
What This Tool Can and Cannot Replace
✓ Works on
- Cell values (text and numbers)
- Formula results (the displayed value)
- All sheets simultaneously
- Case-insensitive or case-sensitive matches
- Partial substring or whole-cell matches
- Replacing matched text with an empty string (deletion)
✗ Does not work on
- Formula text itself (=SUM, =IF, etc.) — only the result
- Cell comments or notes
- Sheet names or named ranges
- Regular expressions / regex patterns
- Formatting — only content values
- Embedded images or charts
When a formula cell matches the find text, the tool replaces its value and converts it from a formula cell to a static value cell. The formula is not preserved — if the cell needs to recalculate from source data, re-enter the formula after replacement.