=IF(MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},D1&"012345678 9"))LEN(D1),0,MIN(SEARCH(
{0,1,2,3,4,5,6,7,8,9},D1&"0123456789")))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"lovemuch" wrote in message
...
In word this is referred to "any digit" and the text you use to find it is
"^#". Is there something similar in Excel?

Thanks!

Cynthia