Mega Code Archive
Search for a value or data in a cell and replace it
Click the cell or cells. Click the Home tab. Click Find & Select button.
Click Replace
Specify the values or data you want to find and replace.
Then click the appropriate Find or Replace buttons.
The data is replaced.