Topic: Find and Replace

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Checking for Messages in Cells If you have a large range of cells that is used to display verification messages for a worksheet, you know that looking through the range to check for messages can be time consuming and prone to errors. This tip examines different ways you can check the cell range using formulas so that you don’t miss a thing in the future. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Finding and Deleting Links A VBA macro to find and delete external links. Microsoft Excel versions: 97 | 2000

Limiting Searching to a Column Find and Replace is one of Excel’s most-used tools when working with large amounts of data. You can also limit the area searched by Find and Replace by simply selecting the area you want searched before you start the search. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Searching for Leading Apostrophes Take a look at the Formula bar when you select a cell that contains text, and you may see an apostrophe at the beginning of the text. Searching and replacing those apostrophes can be frustrating, until you know what they are for. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Searching for Line Breaks If you have line breaks in some of the cells of your worksheet, you might want to search for them. There is no “special character” you can use for the search, like there is in Word. You can easily find the line breaks by using an ASCII code in the search parameters. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Searching for Wildcards When using Find or Find and Replace, you can use the question mark and asterisk as wildcards in your search. If you want to search for those actual characters, you must preface them with a tilde, as explained in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Wildcards in 'Replace With' Text When doing searches in Excel, you can use wildcard characters in the specification of what you are searching. However, you cannot use them in the replacement text. This tip examines ways you can work around this limitation and use wildcards in your replacements. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

More Topics

Tips, Tricks, and Answers

Macros Rock!

Helpful Links

Great Info!

RSS Feeds