Find and Replace
Finds text or finds and replaces text.
-
Find — Displays the text element to be located.
-
Find Next – Finds the next occurrence of the specified text
-
Replace – Replaces the string in the Find field with the text element in the With field.
-
Replace All – Replaces all occurrences of the specified text
Find Options:
- Match Case - Search will be case sensitive
- Match entire cell contents - Entire contents must match to be selected
- Search selected cells - Only the selected cells will be searched