Wildcard for finding the first numeric digit in a cell?
 

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

Wildcard for finding the first numeric digit in a cell?
 

=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

Wildcard for finding the first numeric digit in a cell?
 

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.