Works: Match Whole Word Not Available in Spreadsheet, Database (113860)


The information in this article applies to:

  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 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".

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.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB113860
©2004 Microsoft Corporation. All rights reserved.