Formula for finding any number within text

[btmonroe]

I am trying to determine if a text field has a number or not. I can use the find function, but only one number at a time. Is there a way to search for 1,2,3,4,5,6,7,8,9,0 ?

 

[Oaktree]

=SUM(--ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},A1)))>0, which is an array formula and must be confirmed with CTRL+SHIFT+ENTER instead of just ENTER (doing so correctly will result in Excel putting { }'s around your formula in the formula bar).

 

[btmonroe]

Thanks

Worked like a charm