Using Find and Replace Tool to replace text in Excel

In some previous posts, I have talked that how to use the REPLACE function or Substitute functions to replace text string. And this post will guide you how to use Find and Replace tool to replace text from a worksheet in excel.

The Find and Replace tool is a very useful tool to replace the text string or characters with new text or character in excel. It can change the entire contents of a cell and also can search the content from a specific worksheet or the whole workbook. You can choose its search range while searching.

For example: if you want to change the whole worksheet that contains “word” text to “excel”.  Please refer to the following steps:

1# click on the “Find& Select” button on the Editing group under Home tab.

using find and replace tool1

2# select the Replace tab, then “Find and Replace” window will appear.

using find and replace tool1

using find and replace tool1

3# enter “word” in the text box of “Find what:

4# enter “excel” in the text box of “Replace with:

using find and replace tool1

5# you can also click on the “Format” button to format the content that you are replacing. Such as: you can select “Text” under “Number” tab to format the content as text.

using find and replace tool1

6# click Replace All.  All of text that is searched will be replaced at once.

7# at last, the tool will tell you how many replacements were made, see below screenshot.

using find and replace tool1

The find and Replace tools is also allow to use the wildcards (* , ?) in the Find what field. Such as, replace any cells that starts with the character “e”, then we can enter “e*” into the text box of “Find what”.

More reading: REPLACE function in excel

Related Posts
How to Sort Data but Keep Blank Cells in Excel

In daily work, if we sort data with blank cells included in the same column, these blank cells are listed at the bottom automatically after sorting. If we want to keep the positions of these blank cells unchanged and only ...

How to Copy and Paste Only Values and Ignore Formula

When we copy a cell applied with a formula, we copy the formula of the cell rather than copy the value showing in the cell. In this article we will introduce you the way to copy only value ignoring applied ...

How to Sort Date by Day of Week in Excel

Except sort data by “A to Z” (alphabetical order, for numbers from small to large), we can also sort data by date, month or year if these conditions are given. In this article, we will show you the way to ...

How to Select All Non-Blank Cells of a Range

In daily work, we may meet the cases that select all blank cells or non-blank cells of a range. You may know the way to select all blank cells as they are “blanks”. But for non-blank cells, they may contain ...

How to Get Text before or after Dash Character in Excel
get text before dash8

This post will guide you how to get text before or after dash character in a given cell in Excel. How do I extract text string before or after dash character in Excel. Get Text before Dash Character with Formula ...

How to Insert Dashes in Phone Numbers in Excel
inset dash phone number15

This post will guide you how to insert or add dashes in phone number with a formula in Excel. How do I add dashes to telephone numbers in a selected range in Excel. How to separate numbers with dashes in ...

Fill Blank Cells with specific value (0 or null)
fill empty blank cell with value2

This post will teach you how to fill all blank cells with specific value, such as: 0 or any other values in excel. How to locate all blank cells and then fill in all the blanks with any specific value. ...

Delete Rows Based on Cell Value
remove rows based on values3

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code ...

How to Copy Formula without Changing Cell References
copy formula without changing reference7

This post will guide you how to copy formula without changing its cell references to make an exact copy in excel. How to copy and paste formulas or links without changing Cell References. How to copy exact formula from one ...

How to Check If the First Letter is capitalized
check if first letter capitalized4

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. ...

Sidebar