If you ever want to remove comments or replace them or even show and hide them in huge Excel Sheets and much more, then this is for you. Dose for Excel's Comments utility can implement this with one click on huge number of cells and sheets.
Click DOSE » Comments
1. Select a range of cells.
2. Check the option you need in Comments Assistant:
a. Toggle show or hide comments with a single click.
b. Convert comments to cells text.
c. Convert cells text to comments.
d. Easily delete comments in a range of cells.
e. Resize and position comments of selected cells.
f. Collect comments on all sheets and list them in one sheet column.
g. Replace comment's old value with new one.
3. Then click Apply. You will see the result as shown in the below screenshot.