Find and replace an item

Find and Replace will find a certain set of characters in a worksheet and replace it with another. This feature is useful if your customer wants to change one finish to another globally.

For instance, if the customer has decided to change all black trim to gray.

1. Click on the Standard toolbar.
   
   

2.  In the Find What field, type the information that you want to replace.
   
   

3.  In the Replace With field, type the information that will replace the Find What information.
   
   

4. In Replace In Column, select the column where values will be replaced.
   
   

5. In Replace In Row, change the value to the specific rows you are changing (for example, Options).
   
   
   
   

6. Under Replace In, select All Items or Current Selection (selected by default if there are selected items in the worksheet).
   
   

7. Click Replace to replace one occurrence or Replace All to replace all occurrences.

Remember: you must do an Update Against a Catalog to have the description and / or prices change.

Note: Highlight the information you want to replace before doing a Find and Replace so that the text is automatically entered in the Find What field.  The correct column will also be set in the Replace in Column.

To run Find and Replace again, press F3.