Forum Discussion

Copper Contributor

Oct 25, 2017

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...

Formulas & Functions

Need Help

SergeiBaklan
Oct 26, 2017
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

SergeiBaklan

Diamond Contributor

Oct 25, 2017

Hi Renaut,

Note: Formulas, Values and Comments are only available on the Find tab; whereas only Formulas are available on the Replace tab.

https://support.office.com/en-us/article/Find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

Renaut Michel
Copper Contributor
Oct 26, 2017
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
- SergeiBaklan
  Diamond Contributor
  Oct 26, 2017
  Hi Renaut,
  
  Strange, shall work with Excel 2013. And which of these 3 options (on screenshot) do you see?