Excel:检查单元格是否在文本字符串中包含数字
问题描述：
我有一个工作表，每个单元格中都有文本字符串(文章标题).我想知道一个单元格是否包含数字.例如:
I have a worksheet with text strings in each cell (article title). I'd like to know if a cell contains a number. For example:
'This is 3' --> TRUE
'Red balloon' --> FALSE
' It's 10 things' --> TRUE
更新:此处的所有答案均有效.我只是选择了最短和最简单的方法.
Update: Every answer on here works. I just chose the shortest and simplest.
答
类似于XOR LX的答案，但短2个字符
Similar to XOR LX's Answer but 2 chars shorter
=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1))>0