While working with Excel, you may feel the need to find particular text within a selected cell, or even feel the need to replace that text. Microsoft Excel offers cool features to do this task. In this article, we will see several methods for Excel Replace Text in Selected Cells. For your better understanding, we will use a sample dataset here.
Download Practice Workbook
4 Ways to Replace Text in Selected Cells in Excel
We see the use of the Find and Replace feature, Shortcut for this option, and the use of Wildcard character in this blogpost.
Method 1: Replace Text in Selected Cells Using Find and Replace
So, in our dataset, we want to find Jonny and will replace it with Johnson but not every text. We will find and replace them within our desired selected range of cells.
- First, we will select the range of cells we want to perform find and replace then will go to Editing > Find or Replace.
- As a result, a dialogue box will pop up like the image below.
So, we can see, that 3 results are found.
- Now, if we want to replace type Johnson in the Replace with box and click Replace All. Just remember we have to again select the range to perform Replace with. Otherwise, it will replace all.
- Now, a dialogue box will pop up, and click OK.
- Finally, all 3 findings will be replaced, as you can see in the image below, as the last text Jonny was not in the selected cells, it remained intact.
Read More: Find and Replace a Text in a Range with Excel VBA (Macro and UserForm)
Method 2: Keyboard Shortcut to Replace Text from Selected Cells
If you are a keyboard master, then you will love this section. Excel offers various shortcuts to do the task, Find and Replace is also not an exception, there is a shortcut also for this feature.
- First, select the cells we want to Find and Replace within.
- Then press CTRL+H and a Find and Replace dialogue box will appear.
- Now, we know what to do right? In case you can not recall the steps, please check Method 1. In the box, we will Type Jonny in Find what and type Johnson in Replace with box and finally click Replace All.
- Finally, our dataset will look like the following image.
- Jonny in cell B14 was not in our selected cell range, that is why it is not replaced.
Read More: How to Replace Text in Excel Formula (7 Easy Ways)
- Excel VBA to Replace Blank Cells with Text (3 Examples)
- Replace Text between Two Characters in Excel (3 Easy Ways)
- How to Replace Text with Blank Cell in Excel (5 Simple Methods)
- How to Replace Text with Carriage Return in Excel (4 Smooth Approaches)
Method 3: Replace Text by Wildcard Character
The wildcard is a special character that helps us to match texts in Excel. This is a very handy tool. Excel has three characters as wildcards to use in formulas: Asterisk (*), Question mark (?), and Tilde(~). Here, we will see the use of Asterisk (*) to find and replace text in selected cells.
- At first, select the cell range, we want to perform find and replace.
- Then, press CTRL+H and open the Find and Replace dialogue box. In the Find what box type *Jon.
- If we use Asterisk (*) at the start and type a specific text, it will find all the text that ends with that text.
- If we want to find the text by the first few characters use the following technique.
- In case, we want to find text that contains some specific characters in the middle, the follow the technique below.
- After, finding the texts, type Johnson in the Replace with box and click Replace All.
- Our final result will be as follows.
Read More: How to Replace Text after Specific Character in Excel (3 Methods)
Method 4: Replace Text in Selected Cells for Entire Workbook
Here, we will see, how to find and replace within the entire workbook.
- First, open the workbook and press CTRL+H, which will open the Find and Replace dialogue box. From here, type Jonny and click Find All.
- You know, we have four texts as Jonny in sample data, so in 5 sheets it will count to 20.
- Finally, type Johnson in Replace with box and click Replace All.
That’s it, click on the sheets and we will find Jonny is Replaced with Johnson.
Read More: Replace Text of a Cell Based on Condition in Excel (5 Easy Methods)
The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.
That’s all for the article. These are 4 different methods for Excel Replace Text in Selected Cells. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.
- Excel VBA: How to Replace Text in String (5 Effective Ways)
- Excel Formula to Replace Text with Number (5 Examples)
- Excel VBA: Replace Character in String by Position (4 Effective Ways)
- Excel VBA: Open Word Document and Replace Text (6 Examples)
- Excel VBA to Find and Replace Text in a Column (2 Examples)
- Excel VBA: How to Find and Replace Text in Word Document