2.14.2.Replace Cell Contents |
|
Click A1.
Click the Home tab.
Click the Find & Select button.
Then click Replace.
|
|
 |
Type the text you want to search for.
Type the text you want to substitute.
|
|
 |
Click Find Next to begin the search.
|
|
 |
Click Replace to substitute the replacement text or click Replace All to substitute text throughout the worksheet.
|
|
 |
Click Find Next to locate the next instance of the cell content without replacing.
|
|
 |
|
 |