Home > Features > Data > Search and Replace

Search and Replace

(version 1.1)

Figure 1: Search and Replace

Use Search and Replace to replace text in your data with more meaningful text. This feature is NOT case sensitive and does not have to match the entire cell's contents.

Click the Search and Replace button (Figure 1: item 1) to display the conditional formatting form.  The Enable Search and Replace checkbox (Figure 1: item 2) toggles the feature.  This allows the setting to be turned on or off without changing the actual Search and Replace configuration.

It will perform this function automatically for up to 25 replacements.

Steps  (see Figure 2):

• Click on the button labeled Search and Replace to show the Search and Replace dialog
• In the Search Field specify the scope of the search and replace. Enter one of the following:
  • a column name – if you want to restrict Search and Replace to a specific column or
  • [SHEET] – if you want the entire data set (all columns) to be included
• In the Find field, enter the text to that will be replaced if matched. Wildcard characters can be used in the Find field.

Wildcard	Description
?	matches any single character
*	matches zero or more characters

• In the Replace field, enter the text that will replace the text identified in the Find field

Figure 2: Search and Replace Configuration Form

Notes:
The search is NOT case sensitive.
The search does not have to match the entire cell’s contents.
Limited to 25 search and replace settings

EXAMPLE: Replace a value found in a specifc column.

Download example

Replace Jane with Ms Jane
in the First Name column

EXAMPLE: Replace a value found anywhere in the dataset.

Download example

Replace Doe with Taylor anywhere

in the data set [SHEET]