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

Categorize Text With Keywords

If you are looking for the simplest approach to categorize the text with keywords, then look no further because you have just landed on the right blog post where you will get to know a formula and its usage to ...

Cash Denomination Calculator

Every country has different cash denominations, so you may need to calculate the number of different denominations based on the total amount. If it is just a small amount of cash, then you can calculate the different cash denominations manually, ...

7 Best Free Weekly/Bi-Weekly Budget Template

This article will show you some free printable weekly/ BiWeekly budget templates for google sheet and Microsoft Excel spreadsheet applications, and will also explain some of the features or important functions of these templates. This will make it easy for ...

COUNTIF Function: Everything You Need To Know

In previous articles, we have written a lot about the application of Excel COUNTIF function in specific situations. In today's article, we will still focus on Excel COUNTIF function, we will introduce you some basic functions of COUNTIF function including ...

How to Get Text before or after Dash Character in Excel

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 ...

Sidebar