"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Find and Replace Wildcard Characters (* ?)


If you use Excel a lot, one day you are going to need to do a Find and Replace on text that includes a wildcard character. If you've already come across this situation in the past, you probably remember that it wasn't a simple, straight-forward task. You may have even given up in frustration and did the Find and Replace manually.

The problem is, Excel (and many other programs) use these characters as wildcards to aid in searching. On the rare occasion that you find yourself in this situation, simply precede the wildcard character with a tilde (~). So for example, if you need to replace all asterisks you would use ~* (tilde + asterisk) in your search.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.