Related Topics:

Analysis Workbooks

Find

You can find text and numbers in a value or a formula in the current spreadsheet by choosing Home > Edit > Find to open the Find window.

Click Find Next to find the next matching text and/or number. When the text and/or numbers are found, the cursor will go to that particular cell location.

To replace text and/or numbers, click Replace. The Replace With field will become visible so that you can type the text or numbers that will replace any text or number that matches your search. The Look in option is not available because the Replace feature automatically searches all of the sheet contents.

Tip: To ensure that all instances of searched for text are replaced (including multiple instances within the same cell), you may need to click Replace All several times.

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.