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.
Find
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.
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.
Active cell is moved to the first place in which there is text.
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.
Choose Workbook.
Now Excel will be finding within the entire workbook.
Replace
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.
Open the Find and Replace. Type the word 'HSBC' with a space located after it in the window Replace.
Pane Replace with blank. Click on Replace All.
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?