Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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

↑ Back to the top


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.

↑ Back to the top


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.
  6. 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.
  6. If you do not want to replace the found text, click the Find Next button.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: KB287126, kbpending, kberrmsg, kbbug, kbofficealertid

↑ Back to the top

Article Info
Article ID : 287126
Revision : 3
Created on : 6/4/2007
Published on : 6/4/2007
Exists online : False
Views : 272