How to Find and Replace in Excel

The "Find and Replace" feature in Excel is a powerful tool that allows you to quickly search for and replace specific text or values in your workbook. In this lesson you can learn how to find and replace text in Excel.


Begin by finding the HSBC company in a long list of data in the table. Click Find is located on the Home click on the binoculars Find & Select.

Excel find and replace find select ribbon button

A much simpler way of launching is to select the keyboard shortcut Ctrl + F In the window that opens, enter the required name and click Find Next.

Excel Find And Replace

Active cell is moved to the first place in which there is text.

Excel Find and Replace Cell

After the second click Find Next move to the next cell in which such name is registered or nothing will happen, which means that this name appears only once.

Find within entire workbook

Sometimes you may want to find within every sheet. To do that, click Options.

Excel Find and Replace Options

Choose Workbook.

Excel Find and Replace within Workbook

Now Excel will be finding within the entire workbook.


Replace command is also often used to remove unwanted characters in the cells. In this example, it was considered that the word HSBC is unnecessary for me. Select the area you want to delete this word.

Excel Replace Selected Area

Open the Find and Replace. Type the word 'HSBC' with a space located after it in the window Replace.

Excel Replace HSBC

Pane Replace with blank. Click on Replace All.

Excel Replace HSBC replaced

You made it. The word "HSBC" disappeared.

By default, the "Find and Replace" feature only replaces text within the values of cells. However, you can choose to also replace text within formulas by selecting the "Within formulas" option in the "Replace" tab of the "Find and Replace" dialog box.

Further reading: 
How to fix middle mouse button not working issue?
Getting started with Excel
How to compare columns to find duplicates?