Forum Discussion
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 "look in" option does not offer to search in the "comments" for the function "replace"
Thanks for help
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
6 Replies
- Thank You I understand that choising to find in "comments" is not available when we want to "replace" Is there an other mean than this "box" to solve my problem ? Which is ti "find ans replace" in the "comments" Thanks again for help.
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
Super
Thank you
This seems to be what I am looking for.
Have a good day
Hi Renaut,
==
Note: Formulas, Values and Comments are only available on the Find tab; whereas only Formulas are available on the Replace tab.
==
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?
