How to Edit Data Using the Replace Feature in Microsoft Excel

In the previous post I have explained How to Search Data in Microsoft Excel, so in this post I will discuss about How to Edit Data Using the Replace Feature in Microsoft Excel.To edit existing data in one or two cells alone would be easy for us to do. It only became difficult when we have to edit the data present in many cells. In this example, I will explain how we replace all data Male became Man. 

1. Create a New Workbook (Press Ctrl + N) and then make the data as the example picture I've provided below.

 
2. If you do not select a particular range, then edits the data will be applied to the whole cell. In this example the block range D3: D10 that means edit only applied in the range D3: D10.

3. Select Tab Home> Find & Select> Replace (Press Ctrl + H). Will Appear Find and Replace dialog box Replace tab.

 
4. Type the text that will be replaced in the Find what text box: In the Replace with text box: type in the new data that will be used. If so, press the Replace All to replace all the text in the range that we choose. Then the dialog box will appear as shown below.

 
5. A message box provides information that Excel has done a search and replacement in accordance with the provisions of 5 data that you set. Here I replace Male to Man, and then press the OK button.

 
In addition to changing the data in the entire worksheet or a selected range, you can also change the data contained in the entire workbook. For example, data man in the previous case, we will replace it not only contained in one worksheet. 

1. Select the tab Home> Find & Select> Replace (or press Ctrl + H). Dialog box will appear Find and Replace - Replace tab. 

2. Press the Options >> so the display Find and Replace dialog box will be as shown below.

 
3. Type the text that will be replaced in the Find what text box: Replace with text box: type in the new data that will be used. Select the workbook in korak Within option: Press the Replace All.

4. Confirmation box will appear again, then press the OK button. If Excel can not find the data that should be replaced, it will display a message box as shown below.

 
Thus a brief description of me on How to Edit Data Using the Replace Feature in Microsoft Excel, May be useful for you all.