Find and Replace not finding notes

Copper Contributor

I am using Excel for Office 365 MSO (16.0.11126.20234) 32-bit and recently all my spreadsheets automatically starting using notes instead of comments. My workbooks still have the old existing comments in them but now new comments only input  as "notes." The problem is, the Find and Replace function does not find my notes. It still finds old comments just fine but any new notes I have entered are not discoverable. This is a big problem as I use comments (now notes) extensively to add additional details to my cells. Is anyone else experiencing this and does anyone have any suggestions? Keep in mind, there is no option for "notes" in the "Look in" tab, only Formulas, Values and Comments. Please help!

1 Reply

Hi,

 

I played with that, some story. It looks like the functionality for the comments was not implemented.