How to Use Wildcards to Find and Replace in Excel
By C. Taylor
Microsoft Excel's Find and Replace feature allows you to search for a particular string of text within functions or cell values. If you're uncertain of a particular string of text, you can use wildcards. Wildcards are used as place-holders when you can't specify the exact text in a string. Wildcards are usually used in conjunction with known, partial text to help locate the string within Excel cells.
Open your spreadsheet in Microsoft Excel.
Hold the "Ctrl" key and press "H" to open the "Find and Replace" window.
Enter the search term in the "Find what" field of the Find and Replace window.
Add an asterisk wherever you're uncertain of a section of text. You don't need to use the asterisk wildcard to specify additional text at the beginning or end of a search term. As an example searching for "hot" will find "hot," "shot" or "hotter," even without the wildcard. However, adding the wildcard in the middle of the search text helps locate widely different text. As an example, entering "tr*p" will locate "trip" or "troop."
Enter the replacement text under the "Replace with" field.
Click "Replace All" to automatically find and replace all matches. Alternatively, you can click "Replace next" or "Find next" to replace or locate the next match found.
C. Taylor embarked on a professional writing career in 2009 and frequently writes about technology, science, business, finance, martial arts and the great outdoors. He writes for both online and offline publications, including the Journal of Asian Martial Arts, Samsung, Radio Shack, Motley Fool, Chron, Synonym and more. He received a Master of Science degree in wildlife biology from Clemson University and a Bachelor of Arts in biological sciences at College of Charleston. He also holds minors in statistics, physics and visual arts.