Works: Match Whole Word Not Available in Spreadsheet, Database

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q113860

SUMMARY

The Replace command in the Database and Spreadsheet modules of Works versions 3.0, 4.0, 4.5, and 4.5a do not give you the ability to Match Whole Word or Match Case like you can in the Word Processor module.

For example, if you wanted to replace the word "Mr" with the word "Sirs" in a database, Works would replace all occurrences of "mr" (within any word and in both uppercase and lowercase) in the selected area. As a result, any occurrence of "Mrs" would be replaced with "Sirss".

Back to the top

MORE INFORMATION

WORKAROUND

Copy the information from the Works spreadsheet or database list view that you would like to perform the Replace function on.
Paste the information into a new Word Processor document.
Use the Replace option from the Edit menu in the Word Processor to Match Whole Word or Match Case as desired.
Copy all the information in the Word Processor document.
Paste the information back into spreadsheet cells or database list view fields that it was originally copied from.

Back to the top

APPLIES TO

Microsoft Works 3.0 Standard Edition
Microsoft Works 4.5 Standard Edition
Microsoft Works 4.5a
Microsoft Works 4.0 Standard Edition
Microsoft Works 4.0a

Back to the top

kbinfo KB113860

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