Excel search for a word in a cell

Thank you but when I use the find function or even search the result is always true even if the word is nonexistent in the cell. I don’t understand why.

I just copied your formula and I still get a result equal to true.

Hello
try to complete Marina's formula (bise) who must have made a small oversight, the CHER CHE formula asking for a starting character n°:
=IF(ISERROR(SEARCH("déchet";A1;1));"produit encore valide";"produit à jeter")
by simply adding ;1 after the A1
After testing on my side, it works very well.. provided the spelling of the accented word is properly respected in the sentence
Crdlmnt

--
The truth is not possessed, it is only sought

Hello,

your last remark isn’t very clear
you have to mix text with formulas!
and there are A1, B2, A3 !!

could you send an example file with your message "real"
with https://www.cjoint.com/


Denis

Hello http://www.cijoint.fr/cjlink.php?file=cj200811/cijdfjx8RV.xls Look at the file above to see if it matches what you want to do and, if so, adapt it to your table. Attention to the label "déchet" which must be strictly identical in the formula and in the texts. There are solutions if you have trouble with the spelling of the word searched to fit it into the texts. Crdcmnt -- La vérité ne se possède pas, elle se cherche seulement