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