Follow these steps to find and replace specific data in an Excel sheet:
- Select the particular cells or range where you would like to search for data.
- Go to the Home tab on the ribbon and select Find & Select.
- Choose Find or Replace in the drop-down menu.
- Enter in the data you want to search for or replace.
- For particular cells or a range, choose if you want to do a Match Entire Cell Contents search.
- For a more extensive search, choose Format and click on Find All.
- If replacing data, choose Replace All to replace the data.