Bulk Text Cleaner⌨️ Shortcut: Ctrl+H🎯 Wildcards (*, ?)
Excel Find & Replace: Bulk Data Normalization
Fix inconsistent spellings, replace dummy values (like "N/A" to "0"), and standardize data across thousands of cells instantly with Find & Replace (Ctrl+H).
Live Interactive Simulator: Find & Replace Engine
| Row ID | Country | Status | Sales Rep |
|---|---|---|---|
| #1 | USA | N/A | Jon Smith |
| #2 | US | Active | Jon Smith |
| #3 | United States | N/A | John Smith |
| #4 | USA | Pending | Jon S. |
| #5 | U.S.A. | Active | John Smith |
Type text to find/replace and click "Replace All".
1. What Is Find & Replace (Ctrl + H)?
Find & Replace is one of the fastest built-in tools in Excel for text normalization. It scans your worksheet or selected cell range, identifies specified characters, and automatically substitutes them with new text or formats.
Ctrl + F: Opens the Find tab to jump between matching cells.Ctrl + H: Opens the Replace tab directly for bulk text replacement.
2. Wildcard Power Searching (*, ?, ~)
Excel supports 3 powerful wildcard characters in Find & Replace:
*(Asterisk): Matches ANY sequence of zero or more characters (e.g. searchingUS*matches "USA", "US", "U.S.A.", and "United States").?(Question Mark): Matches exactly ONE single character (e.g.Cat?matches "Cats" or "Cart").~(Tilde): Escapes wildcards so Excel treats them as literal characters (e.g.~*finds an actual asterisk symbol).
Pro Tip: To bulk delete unwanted text (like stripping "USD $" prefixes), leave the "Replace with:" input field completely BLANK and click Replace All!
3. Advanced Options: Match Case & Match Entire Cell
Clicking the Options >>button inside the Find & Replace dialog unlocks critical precision controls:
- Match Case: Enforces case-sensitivity (e.g. replaces "apple" without touching "Apple").
- Match Entire Cell Contents: Prevents partial substring matching. For example, replacing "Cat" won't accidentally corrupt the word "Category"!
- Search Within Workbook: Changes search scope from just the current sheet to ALL worksheets in the workbook at once.
🔍
Test Your Find & Replace Knowledge
5 questions covering shortcuts, wildcards, tilde escaping, and bulk text stripping.