在单元格字符串中查找问号
问题描述：
我想确定Excel 2010中单元格中的字符串是否包含以下任意一项，然后返回"1".
I would like to find out if a string within a cell in Excel 2010 contains any of the following, and then return a '1'.
-
?dementia
? dementia
dementia?
dementia ?
我已经尝试了一些公式，但是当组合使用它们时，它们似乎无法克服通配符和字符串的使用.
I've tried some formulas but they don't seem able to get past the use of the wildcard and the string when combined.
有人会提供任何指示或建议吗?
Would anyone have any pointers or advice?
答
这是您需要的公式:
=IF(IFERROR(FIND(A2,$C$3),0)>0,1,0)
其中A2是您要检查的字符串.
where A2 is the string that you are trying to check.