Excel Find and replace operations

      Find and replace is an operation that is often performed during editing, in addition to finding and replacing text in Excel, you can find and replace formulas and notes that are more widely used and further improve the efficiency of editing processing. With these features, we can quickly find cells that have special characters in all worksheets except the Visual Basic module. We can replace existing characters with another string of characters in all cells in a worksheet, in one selection on a worksheet, or in the current selection of a worksheet or worksheet group. You can also find and select cells that have similar content.
5.6.1 Find Commands
     when you want to review or modify a part of a worksheet, you can find and replace any specified values, including text, numbers, dates, or find a formula, a note. For example, we can specify that Excel finds only special text with some uppercase format. For example, you can look for "green" instead of looking for "green".
     Perform a lookup operation as follows:
     (1) to perform the Find command on the Edit menu, the screen displays a dialog box.

(2) In the Find What box, enter the string you want to find, and then specify the search by and search scopes, and then press the Find Next button to start looking for work.
(3) When Excel finds a matching content, the cell pointer points to the cell. Then we can decide what to do next, and if we need to find it further, we can select and press the "Find Next" button, or you can choose the "Close" button to exit the Lookup dialog box.

Tip: You can enter up to 255 English characters (one Chinese character equals two letters) in the search target. Because the lookup target box can display a few words, when we enter a string that exceeds its display range, Excel automatically scrolls the string to display the data over the range. We can also scroll the string by moving the cursor.
Excel also provides a lookup of formulas and notes.
Tip: If you want to perform a find or replace work on a worksheet, you can select it as a worksheet group before you perform the appropriate action.
5.6.2 Substitution command
The substitution command is similar to the lookup command, which converts the found string to a new string to facilitate editing of the worksheet.
The steps to perform a replacement are as follows: Perform the Replace command on the Edit menu, and the screen displays a dialog box.

In Find what, enter the string you want to find, and then enter the new data in replace value. Then press the "Replace" button.
You can also press the Find Next button, and when Excel finds it, it points the cell pointer to the cell you find, replacing the target string with the replacement button, and then pressing the Find Next button if you don't want to replace the found string. If you need to replace all the found strings with a new string, you can press the Replace All button, and all of the strings are replaced by the new string. Instead of requiring confirmation on a successive basis to save time.