To find and replace text within a worksheet

·       Place the insertion point where you want to begin the search.

·       Select the Replace command from the Edit menu, or press Ctrl+H to display the Replace dialog box.

·       Type the text you wish to find and replace in the Find what text box, this can be up to 255 characters in length.

·       Type the replacement text in the Replace with text box. Select from the following:

Find Next

Finds the next occurrence of the text

Replace

Replaces this instance of the text.

Replace All

Will replace all occurrences of the text in the Find What section with the text in the Replace With section.

·       Select Cancel to stop the search or to close the dialog box.