Hi,
Please can you me as I have million names and I want to know it is Contain "?" or not.
Please check attached sample.
Thanks;
Ehab Ali
In cell C2 enter =ISNUMBER(FIND("?",A2))
Thank you very much.
Hi Sunny,
I see it works, but can't figure out why it works? What does the 'isnumber' while nothing is a number??
Maybe you can explain in normal English? Thanks in advance!
Frans
Hello,
What FIND function gives you is the character position number if it finds what is looked for, else a #VALUE! error. By wrapping this with the ISNUMBER function you then get a TRUE or FALSE value.
https://support.office.com/en-us/article/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628
https://support.office.com/en-us/article/is-functions-0f2d7971-6019-40a0-a171-f2d869135665
Hi Frans
Anders had described exactly what I was doing. Thanks Anders.
Sunny
Hello,
I also found this blog article that covers this topic.
https://www.myonlinetraininghub.com/excel-search-and-you-will-find
Thanks boys! Nice to keep on learning here!
Frans