Microsoft KB Archive/287126

= Error message when you click the Replace button in the &quot;Find and Replace&quot; dialog box: &quot;Microsoft Excel cannot find a match&quot; =

Article ID: 287126

Article Last Modified on 6/4/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



This article was previously published under Q287126



SYMPTOMS
In Microsoft Excel, when you click the Replace button in the Find and Replace dialog box, you may receive the following error message:

Microsoft Excel cannot find a match.

To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

100214



CAUSE
This behavior can occur if both of the following conditions are true:
 * The active cell does not contain a match.

-and-
 * You do not click the Find Next or Find All button before you click the Replace button.



WORKAROUND
To work around this behavior, use one of the following methods.

Method 1: Use Replace All
NOTE: Use this method only if you want to replace all matches in the workbook.
 * 1) Press CTRL + H.
 * 2) In the Find and Replace dialog box, type the text that you want to replace in the Find what box.
 * 3) In the Replace with box, type the text that will replace the original text.
 * 4) Click the Replace All button.

Method 2: Use Find and Replace

 * 1) Press CTRL + H.
 * 2) In the Find and Replace dialog box, type the text that you want to replace in the Find what box.
 * 3) In the Replace with box, type the text that will replace the original text.
 * 4) Click the Find Next button.
 * 5) If you want to replace the found text, click the Replace button.

Excel automatically finds the next instance of the text that you want to replace.
 * 1) If you do not want to replace the found text, click the Find Next button.

Method 3: Use Manual Find

 * 1) Select a cell that contains the text that you want to replace.
 * 2) Press CTRL + H.
 * 3) In the Find and Replace dialog box, type the text that you want to replace in the Find what box.
 * 4) In the Replace with box, type the text that will replace the original text.
 * 5) Click Replace.

Excel replaces the text and automatically finds the next instance of the text that you want to replace.
 * 1) If you do not want to replace the found text, click the Find Next button.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2002 OfficeErrorMessages 10044 XL2007 XL2K7 XL2003 XL2K3 100214

Keywords: kbofficealertid kbbug kberrmsg kbpending KB287126

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.