Microsoft KB Archive/113860

= Works: Match Whole Word Not Available in Spreadsheet, Database =

Article ID: 113860

Article Last Modified on 11/15/2004

-

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

-



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".



WORKAROUND

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

Additional query words: 3.00 4.00 4.00a 4.50 4.50a kbhowto find search change wrong w_works

Keywords: kbinfo KB113860

-

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

© Microsoft Corporation. All rights reserved.