How to Find and Replace Text in Comments in Excel Office 365?
Tags: findandreplacetextin, kutoolsexceltutorial, kutools
Published: 2020-11-03 11:52:51

---
title: How to Find and Replace Text in Comments in Excel Office 365?
published: true
date: 2020-11-03 11:52:16 UTC
tags: FindandReplaceTextin,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-find-and-replace-text-in-comments-in-excel-office-365/
---

In this article, we will discuss how to **Find and Replace Text in Comments in Excel Office 365** using **Kutools. ** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Find and Replace Text in Comments:

If you have many comments with the same data and you want to replace them, then follow the below steps.

- You need to **activate the worksheet** that you want to find the same data in the comments and replace them with another same content.
- In the below example image, we have shown the comments box with the monthly turnover data. You can see that each comment has the same year **2019,** and we are going to replace them.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-6.png)<figcaption id="caption-attachment-16752">Example</figcaption>

- Next, go to the **Kutools Tab, select** the **More** option, then **choose** the **Find/Replace Comment Text** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-1.png)<figcaption id="caption-attachment-16753">Kutools Tab</figcaption>

- It will display **Find/Replace Comment Text Dialog Box**.
- **Scope –** In this drop-down list, you need to **select** the **Active sheet** ( **Replace data only in**  **the active sheet** ) or **All Sheets** ( **Replace data in the whole workbook** ) option.
- **Find text in comments** – Here, you have to **enter the data** that you want to replace.
- **Replace with –** In this section, you need to **type the data** that you want to **replace** with the original data.
- Finally, hit the **Replace** button.

![Click the Replace button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-Replace-button.png)<figcaption id="caption-attachment-16754">Click the Replace button</figcaption>

- Then, a dialog box will pop-out to tell you how many comments have been replaced.
- You need to **click** the **OK** button to close this dialog box.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Hit-the-OK-button.png)<figcaption id="caption-attachment-16755">Hit the OK button</figcaption>

- At last, you can see that the specific data in the comments have been replaced with new content as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-2.png)<figcaption id="caption-attachment-16756">Result</figcaption>

## Verdict:

In the above article, you can easily understand the steps to **Find and Replace Text in Comments in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Find and Replace the Similar Records from a List of Cell Values in Excel?](https://geekexcel.com/how-to-find-and-replace-the-similar-records-from-a-list-of-cell-values-in-excel/)
- [Copy Multiple Selections in Excel Office 365!!](https://geekexcel.com/how-to-copy-multiple-selections-in-excel-office-365/)