Forum Discussion
Solved
SEARCH and REPLACE
Dans ma version d'Excel (2013) L'option "regarder dans" ne propose pas de rechercher dans les "commentaires" pour la fonction "remplacer" Merci pour votre aide In my version of Excel The "l...
Renaut, to my knowledge that's only using VBA, see for example https://www.extendoffice.com/documents/excel/680-excel-find-and-replace-in-comments.html or https://excel.tips.net/T003534_Finding_and_Replacing_Text_in_Comments.html
Hello Sergei
Thank you for your help.
I had already read this explaination.
The problem is there :
"To search for data with specific details, in the Look in box, click Formulas, Values, or Comments."
At this step I don't see the option "comments" in the look box
My Excel is on PC Windows 10 64 bits version 2013.
Thank you if you can help.
Michel
Hi Renaut,
Strange, shall work with Excel 2013. And which of these 3 options (on screenshot) do you see?