Knowledge Base

Works: Match Whole Word Not Available in Spreadsheet, Database

Article ID: 113860

Article Last Modified on 11/15/2004

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

MORE INFORMATION

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.