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

=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

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

If you need to do this often, define a name like seq referring to

=ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,1024,1))

then use the array formula

=MIN(IF(ISNUMBER(-MID(x,seq,1)),seq))

to find the first decimal numeral in x. It returns 0 if there are none.