Search and Replace Utility

Using the Replace All Command:

1.Select the range of cells you want to search in.

2.Click on EDIT-> FIND and REPLACE

3.Type the text or numbers that you want to search for box or choose a recently searched for item from the search for drop down.

4.Click on the MORE OPTIONS button to further refine your search.

5.Type the replacement texts, characters or numbers in the replace with box and choose specific formats if necessary.

6.Click on the FIND button.

7.Click in the REPLACE button or REPLACE ALL button to replace the highlighted occurrence or all occurrence of the found character.