Replacing a string Clause Samples

Replacing a string. The Replace function operates in the same way as the Search function except that it is capable of replacing the search string by another. Enter the text to be found in the Find box then press Search. The program moves to the first label cell containing the given string then asks for the confirmation before replacing. The possible choices are as follows: Yes The string is replaced and the search continues. No The string is not replaced but the search continues. Cancel The string is not replaced, the search stops, but prior replacements are not cancelled. Whole word: if the Whole word option is checked, the search function only takes into account cells in which the search string constitutes a separate word (e.g. if you search for print with the whole word option, the program will not stop on printer). Exact case: if the Exact case option is checked, the search function only takes into account cells in which the search string is written in exactly the same way, taking account of upper and lower case.