Related Topics: | ||
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.
Use the Find What field to type the text and/or number you want to find in the current sheet.
Use the Search drop-down list to select the order in which to search. If you select By Rows, each row will be searched all the way across before the next row is searched. If you select By Columns, each column will be searched all the way down before the next column is searched.
Use the Look In drop-down list to select where to look. If you want to find text or find a number that is the result of an equation, select to look in Values. If you want to find a number that is within an equation, select to look in Formulas.
Select Match Case to find only the text in the current sheet with the same case. For example, the search term "teXt" will not find "Text" because the case does not match.
Select Find Entire Cells Only to find only cells where the entire cell matches the text and/or number you specified. If your search term makes up only part of a cell, that cell will not be found.
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.
To replace all instances without review, click Replace All.
To review the instances before replacing the material, click Find Next to locate the first place the material occurs, then either click Find Next to leave the current match as-is and find the next occurrence or click Replace to replace the current match and find the next occurrence.
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.