#215 Using Wildcards with Find and Replace

February 20, 2014

You can use the Find and Replace feature in Microsoft Office products to make quick and easy edits to text.  Wildcards are special characters you can use to make searching through your documents more efficient.  Here are some useful wildcard characters:

 

  • Use an asterisk (*) to find any string of characters, including space and punctuation characters.

Ex: searching “s*d” finds sad, started, and significantly altered

  • Use a question mark (?) to find any single character, including space and punctuation characters.

Ex: searching “s?t” finds sat, set, and sit 

  • Use the at sign (@) to find one or more occurrences of the previous character or expression.

Ex: searching “lo@t” finds lot and loot

 

You can mix and match wildcard characters for efficient removal or replacement of text.  For example, you can search “$*.??” to find any dollar amount that you have in the document and choose to delete or replace it. 

 

For a full list of wildcard characters, please see this Microsoft Support Guide.

Latest News

  • The Box team recently announced a new and improved, more personalized user experience with interface changes and backend improvements. Read on for more details
  • This year a new Special print account is being added for all Penn Law students. This account is to be used when printing for approved group and programs. All other printing remains the same, please read on for more details.