The Find and Replace dialog box, available under the Search menu or by pressing Ctrl+F, is used for searching the file for the specified text. The search is performed in the direction specified, Next or Previous. If the string is not found, the search wraps around to the other end of the file and continues the search (when the Wrap Around check box is marked). If the string is not found a message is displayed.
In addition to searching for printable characters, tab and newline (carriage return and line feed) characters may be searched for. To search for the tab character use ^t in the Find field. To search for the newline characters use ^p for CR/LF, ^n for LF only, and ^r for CR only in the Find field. To search a ^ character use ^^ in the Find field.
Find Non-Printable Characters
Search for |
Use |
Tab character |
^t |
Newline characters (CR/LF) |
^p |
LF only |
^n |
CR only |
^r |
^ character |
^^ |
Find Dialog Box Buttons
| • | Count - Counts and displays the number of times the find string is found in the file. |
| • | Help - Displays this help page. |
| • | Replace All - Replaces all occurrences of the find string with the replace string. |
| • | Replace - Replaces the find string with the replace string in the current cell. |
| • | Replace & Find - Replaces the find string with the replace string in the current cell then finds the next occurrence of the find string. |
| • | Previous - Finds the previous occurrence of the find string. |
| • | Next - Finds the next occurrence of the find string. |
Options
| • | Ignore case - Performs case insensitive search when marked, otherwise the case must match. |
| • | Wrap around - When marked, the search wraps around to the other end of the file when the string is not found. Search will stop at the beginning or end of the file when this option is not marked. |
| • | Contains - Find the cell containing the substring specified in the Find field. |
| • | Starts with - Find the cell with the value that starts with the string specified in the Find field. |
| • | Full word - Find the cell with the value matching the string specified in the Find field. |
