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.

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.

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

The active cell will move to the first cell that contains the text you entered. If no cells contain the text, nothing will happen.

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

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 will replace all instances of the found text with the replacement text.

See also  How to Recover Excel File After Crash

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.

Advanced Find and Replace Techniques

In addition to the basic find and replace techniques discussed above, Excel also offers a number of advanced techniques that can be used to find and replace text more precisely.

Case-sensitive search

By default, the Find and Replace feature is not case-sensitive. This means that the text you enter in the Find what box will be matched with any text, regardless of its case. To make the search case-sensitive, select the Match case checkbox in the Find and Replace dialog box.

Whole words only

By default, the Find and Replace feature will match any text that contains the text you enter in the Find what box. To match only whole words, select the Whole words only checkbox in the Find and Replace dialog box.

Regular expressions

Regular expressions are a powerful tool that can be used to find and replace text in a more precise way. For example, you can use regular expressions to find all cells that contain a phone number, or all cells that contain a date. To learn more about regular expressions, please refer to the Excel documentation.

Advanced Find and Replace options

The Find and Replace dialog box also offers a number of other advanced options, such as the ability to find and replace text within formulas, the ability to find and replace text in multiple sheets, and the ability to find and replace text based on a specific date or time. To learn more about these options, please refer to the Excel documentation.

See also  Excel Functions for Beginners: A Guide to Getting Started

Things to Remember

  • The Find and Replace feature is a powerful tool that can be used to quickly search for and replace specific text or values in your workbook.
  • To find text, open the Find and Replace dialog box by pressing `Ctrl + F`.
  • To replace text, type the text you want to find in the Find what box and the text you want to replace it with in the Replace with box.
  • To find and replace text within the entire workbook, select the Workbook option in the Options dialog box.
  • To remove unwanted characters from cells, type the unwanted character in the Find what box and leave the Replace with box blank.