How do I check if a given cell contains any number?-CodePudding

Home > database > How do I check if a given cell contains any number?

How do I check if a given cell contains any number?

Time：10-27

I tried with =COUNT(FIND({0,1,2,3,4,5,6,7,8,9},B3))>0, as shown here

CodePudding user response：

try:

=INDEX(REGEXMATCH(A2:A&""; "\d "))

CodePudding user response：

Just for the record, the count/find formula does work if array-entered:

=ArrayFormula(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0)