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.