Works: Find and Replace in Spreadsheet Cannot Find a Match

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q265909

Expand all | Collapse all

SYMPTOMS

When you attempt to replace text in a cell in Microsoft Works Spreadsheet, you may receive the following message:

Works did not find a match.

Back to the top

This behavior can occur if the text that you are attempting to replace contains a percent sign (%) or a dollar sign ($).

Works Spreadsheet interprets the percent sign and the dollar sign as formatting.

Back to the top

RESOLUTION

To work around this behavior, find all percent signs and dollar signs and manually replace them with the appropriate text. To do so, follow these steps:

On the Edit menu, click Find.
In the Find what box, type the character that you want to find (either % or $).
Click Find Next.
When the data is found, manually replace the character in the cell.
Repeat steps 3 and 4 until you have replaced all the characters.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

APPLIES TO

Microsoft Works 6.0
Microsoft Works Suite 2001
Microsoft Works 7.0
Microsoft Works Suite 2002
Microsoft Works Suite 2003

Back to the top

kbbug kbgraphic kbpending KB265909

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top