2.14.2.Replace Cell Contents |
|
Click A1.
Click the Home tab.
Click the Find & Select button.
Then click Replace.
|
|
![Click the Home tab. Click the Find & Select button. Then click Replace.](../../Microsoft-Office-Excel-2007Images/Replace_Cell_Contents___Click_Home_Tab_Click_Find__Select_B.PNG) |
Type the text you want to search for.
Type the text you want to substitute.
|
|
![Type the text you want to search for. Type the text you want to substitute.](../../Microsoft-Office-Excel-2007Images/Replace_Cell_Contents___Type_Text_You_Want_To_Search_For_Ty.PNG) |
Click Find Next to begin the search.
|
|
![Click Find Next to begin the search.](../../Microsoft-Office-Excel-2007Images/Replace_Cell_Contents___Click_Find_Next_To_Begin_Search.PNG) |
Click Replace to substitute the replacement text or click Replace All to substitute text throughout the worksheet.
|
|
![Click Replace to substitute the replacement text or click Replace All to substitute text throughout the worksheet.](../../Microsoft-Office-Excel-2007Images/Replace_Cell_Contents___Click_Replace_To_Substitute_Replace.PNG) |
Click Find Next to locate the next instance of the cell content without replacing.
|
|
![Click Find Next to locate the next instance of the cell content without replacing.](../../Microsoft-Office-Excel-2007Images/Replace_Cell_Contents___Click_Find_Next_To_Locate_Next_Inst.PNG) |
|
![Click Close.](../../Microsoft-Office-Excel-2007Images/Replace_Cell_Contents___Click_Close.PNG) |