Select the range of cells that you want to search or replace it. click on the find & replace button in the editing group on the home. enter the text or value you want to find in the find what field from find and replace dialog box that appears. click on the options button and specify the formatting options for searching the specific format. click on find next to locate the first text value in the range. And click find next repeatedly to find each subsequent. Click on replace to replace the text in a range. Then click on close to close the dialog box.